Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “apices” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
apices10491626(None) 
amices105018011amices
spices104326031spices
abides94719892abides
aces67645092a__ces
advices13136932advices
aides65336602a_ides
alines65735222alines
alpines94016192alpines
amice96122872amice_
amicus103810002amicus
amides95722662amides
amies76837692ami_es
amines84727982amines
animes84719592animes
anises64826692anises
apace94718382apace_
apaches143411832apaches
apes66047432ap__es
apexes1539132apexes
aphides134711202aphides
apical10913902apical
apicals1159922apicals
apiece10510082apiece
aplites9314932aplites
apples104315762apples
apres75426402ap_res
apses76823912ap_ses
apsides103911302apsides
arises65233802arises
asides75118872asides
aspics104211562aspic_s
aspires9612042aspires
aspises9611642aspises
auspices1236442auspices
axises134413992axises
axites134913832axites
azides165113802azides
azines155517072azines
bices95029962_bices
calices114321692calices
capizes20410372capizes
caprices1439892caprices
carices114220952carices
deices94119372deices
dices86434242_dices
epics95014282epic_s
fices106031162_fices
ibices10398162ibices
ices66129642__ices
juices1549422juices
lapides103012042lapides
lapises93513462lapises
latices9313762latices
malices114316622malices
opines84820702opines
paces96741112_paces
picas94626522_picas
pice84641092_pice_
picks135226142_picks
pics85633912_pic_s
pieces104217272_pieces
pies66949602_pi_es
pikes115031032_pikes
piles74742612_piles
pines76048862_pines
pipes96030142_pipes
pixes144323172_pixes
prices104524542prices
puces94924632_puces
radices102314262radices
rapines95120862rapines
rices75536152_rices
saices84221802saices
sices75637272_sices
slices84022852slices
spaces104722632spaces
spicas104715822spicas
spice95528812spice_
spiced115218312spiced
spicer104719312spicer
spicers113815552spicers
spicey134414232spicey
spicks144814992spicks
spics94123242spic_s
spies76037622spi_es
spikes124520712spikes
spiles84227912spiles
spines85132032spines
spires84628112spires
spites84127332spites
splices113914382splices
tapises92914012tapises
trices84826332trices
varices123313572varices
vices105725532_vices
voices114414012voices

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.343520965.0
2DLD Change Limit82551972.56332208.7
3Display Results97970.0303233.3
 (SQL Overall)178691972.93660862.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.