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 “climaxes” with Change Limit: [1] [2] [3] [4]

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

80 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
climaxes194461(None) 
climates12311971climates
climaxed2043111climaxed
climate11312832climate_
climax1735652climax__
climaxless2151082climaxless
climes104720002clim__es
acclimates1645913acclimates
aliases7914493ali_ases
alidades1037003alidades
animates101316423animates
caimans113811783caima_ns
califates14310113califates
camases114216343c_amases
celibates1358633celibates
cellmates1347513cellmates
chamades16138653chamades
chicanes1559373chicanes
chimars144010593chima_rs
chimeres153511313chimeres
chimes134922573chim__es
ciliates10413453ciliates
cimices13279803c_imices
clades94920463cl__ades
claimants1344283claimants
clambakes1943313clambakes
claves115020063cl__aves
cleaves124111623cl_eaves
clematis1248653clematis
cliches144213743cli_ches
climatal1244403climatal
climatic1448733climatic
climatizes23116133climatizes
climaxing2143493climaxing
climbed14336983clim_bed
climber13449133clim_ber
climbers14318413climbers
climbs12498723clim__bs
clime95720893clim__e_
clinches153910373clinches
clines84926043cli__nes
cliques18309203cli_ques
coaxes154715633c__oaxes
coinages11310803coinages
coinmates1348343coinmates
collimates1447973collimates
comakes154413643c_omakes
comates114123643c_omates
commixes2177353commixes
cremates124216013cremates
crimes105521583crim__es
crimples14308963crimples
disclimaxes2352243disclimaxes
flaxes165015353fl__axes
flimsies1335783flimsies
glimes94717523glim__es
glimpses1343953glimpses
grimaces1355383grimaces
images91411463__images
laxes125430093_l__axes
lianes63819323_li_anes
ligases82310713_ligases
ligates82318383_ligates
limans84816303_lima_ns
limas75627633_lima__s
limeades11116643_limeades
limes75636503_lim__es
limites92915453_limites
linages8813173_linages
lipases9209483_lipases
maxes145629533___maxes
minimaxes2043943minimaxes
plumages1335653plumages
primages13159273primages
primates121515933primates
reimages1138373reimages
slimes84722043slim__es
smilaxes1744653smilaxes
subclimaxes2451543subclimaxes
ultimates1148433ultimates

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit146162808.47017256.4
3Display Results80800.0332424.2
 (SQL Overall)178691808.92320025.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.