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

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
concentration175801(None) 
concentrations1877071concentrations
concentrating1856432concentrating
concentrative2056212concentrative
concentrator1655332concentrat_or
deconcentration20103622deconcentration
reconcentration1963992reconcentration
cogeneration1546443co_generation
concelebration20133563concelebration
concentrate15118353concentrat__e
concentrated17116733concentrat_ed
concentrates16118213concentrat_es
concentrators1754993concentrators
condensation1546783conden_sation
confederation1995253confederation
consecration1649783conse_cration
contestation1448663contest_ation
accentuation1653464_accentuation
cancelation1547784cance__lation
cancellation1655024cance_llation
cementation1559704c_ement_ation
coacervation1964274coace_rvation
cogenerations1655914co_generations
commemoration1853884commemoration
commendation1946514commen_dation
commensuration20162984commensuration
compensation18126504compen_sation
concatenation1764094concatenation
concelebrations21103164concelebrations
concentratedly2262174concentratedly
concentric1346134concentr__i_c
concentricity1963724concentricity
conception16410454conce___ption
concertino14910844conce__r_tino
conciliation1648234conc_iliation
concretion1449294conc___retion
concretization2754374concretization
condemnation1746044conde_mnation
condensations1646274conden_sations
condonation1448854condon__ation
confederations20104604confederations
configuration1954134configuration
conflagration1953014conflagration
confrontation1853224confront_ation
confutation1668724con_fut_ation
congelation14410344conge__lation
conjuration2049514con__juration
connation11314264con__n__ation
connotation1347984con__notation
consecrations1749214conse_crations
conservation1749404conse_rvation
consideration1655524consideration
conspiration1648384con_spiration
consultation1447474consult_ation
contemplation1985264contemplation
contention12412224conten___tion
contestations1547744contest_ations
continuation1448194contin_uation
contraction15411244co___ntraction
contraption1548104co___ntraption
contrition12411424co___ntrition
convention15410564conven___tion
conversation1747804conve_rsation
cooperation15410024coope__ration
cunctation1476914cunc__t_ation
deconcentrating2163084deconcentrating
fenestration1596074fen_estration
fomentation1647714fo_ment_ation
incantation1347054_incant_ation
incineration1446294_incineration
indentation1248374_indent_ation
inteneration1248634_inteneration
noncelebration18113314noncelebration
orchestration1883644_orchestration
orientation1147574_orient_ation
ostentation1146974_ostent_ation
penetration1349894pen_e_tration
placentation1694154placent_ation
potentiation1455974po_tentiation
reconcentrating2063344reconcentrating

Search took 10 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.796224486.2
2DLD Change Limit95024808.42311281.5
3Display Results80800.0461739.1
 (SQL Overall)178691809.26519286.7
 
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.