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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
recommendation218322(None) 
recommendations22113091recommendations
commendation1946512__commendation
commendations2055803__commendations
decompensation2193363decompensation
recombination19106173recombin_ation
recommendatory24121403recommendatory
accommodation22152614accomm_odation
commination171111644__commin_ation
compensation18126504__compensation
decompensations22103044decompensations
emendation1346554_e___mendation
recombinations2095594recombin_ations
recommendable2271934recommenda_ble
recommending2053234recommend__ing
recompilation1955154reco_mpilation
recomputation1974394reco_mputation
reconcentration1963994reconcentration
recondition1447124reco___ndition
reconsecration1885564reconsecration
recordation1449264reco___rdation
recrimination1757404recrimin_ation
refoundation16102794refo__undation
regimentation1695434re_gimentation
renomination1499184reno_min_ation
reorientation1375594re_orientation
accommodations23202505accomm_odations
cementation1559705__c_ementation
combination17108805__combin_ation
commemoration1853885__commemoration
commendatory2253235__commendatory
commensuration20162985__commensuration
commentating1957045__commentating
commentator1755275__commentat_or
comminations18810485__commin_ations
comminution17105015__commin_ution
communication21106215__communication
communization28116685__communization
commutation1748005__comm_utation
compellation1855105__compellation
compensations19136185__compensations
condensation1546785__condensation
decompensating2262525decompensating
deconcentration20103625deconcentration
decondition1545415deco___ndition
deconsecration1954785deconsecration
denomination15118835deno_min_ation
depigmentation20103045depigmentation
documentation18144725doc_umentation
emendations1446055_e___mendations
excommunication3062505excommunication
fecundation1743575fec___undation
fermentation1756825fe__rmentation
fomentation1647715__fo_mentation
precondition1755245preco___ndition
preconvention2074005preconven__tion
predomination1896535predo_min_ation
prenomination17126755preno_min_ation
recantation1349865rec___antation
reclamation1546355reclam___ation
recodification22125665recodification
recognition1445205reco__gn_ition
recollection1654855recolle__ction
recolonization25155885recolonization
recombinational21102025recombin_ational
recommencing2153335recommen__cing
recommend1664325recommend_____
recommended1953145recommend___ed
recommender1852725recommend___er
recommenders1952125recommend__ers
recommends1763165recommend____s
recommission1853745recomm__ission
recompilations2054955reco_mpilations
recomposition1953415reco_mposition
recomputations20104105reco_mputations
reconception1855645reconce__ption
reconciliation1854125reconciliation
reconditions1546825reco___nditions
reconfirmation2153225reconfirmation
reconnection1655995reco__nnection
reconsecrations1995105reconsecrations
recontamination1983545recontamin_ation
recordations1548645reco___rdations
recreation12413615rec__re__ation
recriminations1856725recrimin_ations
recuperation1656725rec_upe_ration
reexamination22153665reexamin_ation
reforestation1654575refo_restation
reformation1648415reform___ation
reformulation1853975reform_ulation
refoundations17102635refo__undations
regimentations1784855re_gimentations
rejuvenation22123005re_juven_ation
remediation1449215re___mediation
remuneration1446935re__muneration
renominations15108305reno_min_ations
reoperation13410905re_o_pe_ration
reorientations1465215re_orientations
reoxidation1946655re_o__xidation
representation16154125representation
sedimentation1654835se_dimentation
segmentation1556005se__gmentation

Search took 8 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 Filter178691950240.376475242.0
2DLD Change Limit950241026.81013953.6
3Display Results1021020.0631619.0
 (SQL Overall)1786911027.24924650.4
 
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.