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 “concentrations” 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.

78 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
concentrations187707(None) 
concentration1758011concentration_
concentrating1856432concentrati_ng
concentrators1754992concentrat_ors
cogenerations1655913co_generations
concelebrations21103163concelebrations
concentrates16118213concentrat__es
concentrative2056213concentrati_ve
concentrator1655333concentrat_o_r
condensations1646273conden_sations
confederations20104603confederations
consecrations1749213conse_crations
contestations1547733contest_ations
deconcentration20103623deconcentration_
reconcentration1963993reconcentration_
accentuations1753094_accentuations
cancelations1657094cance__lations
cancellations1754394cance_llations
cementations1659014c_ement_ations
coacervations2053874coace_rvations
cogeneration1546444co_generation_
commemorations1953444commemorations
commendations2055804commen_dations
commensurations21182584commensurations
compensations19136184compen_sations
concatenations1873724concatenations
concelebration20133564concelebration_
concentrate15118354concentrat___e
concentrated17116734concentrat__ed
concentratedly2262174concentratedly
conceptions17410594conce___ptions
concertinos15158124conce__r_tinos
conciliations1747204conc_iliations
concretions1549294conc___retions
concretizations2854034concretizations
condemnations1845404conde_mnations
condensation1546784conden_sation_
condonations1548004condon__ations
confederation1995254confederation_
configurations2063704configurations
conflagrations2052724conflagrations
confrontations1962784confront_ations
confutations1767794con_fut_ations
congelations1549734conge__lations
conjurations2148494con__jurations
connations12312944con__n__ations
connotations1447284con__notations
consecration1649784conse_cration_
conservations1849094conse_rvations
considerations1764844considerations
conspirations1747724con_spirations
consultations1546934consult_ations
contemplations2074734contemplations
contentions13412094conten___tions
contestation1448664contest_ation_
continuations1547144contin_uations
contractions16410404co___ntractions
contraptions1647644co___ntraptions
contritions13410914co___ntritions
conventions16410534conven___tions
conversations1847454conve_rsations
cooperations1659194coope__rations
cunctations1576154cunc__t_ations
deconcentrating2163084deconcentrati_ng
fenestrations1695404fen_estrations
fomentations1746794fo_ment_ations
incantations1446644_incant_ations
incinerations1545684_incinerations
indentations1347884_indent_ations
intenerations1347464_intenerations
noncelebrations19122824noncelebrations
orchestrations19113304_orchestrations
orientations1246914_orient_ations
ostentations1246124_ostent_ations
penetrations1448854pen_e_trations
placentations17103634placent_ations
potentiations1555184po_tentiations
reconcentrating2063344reconcentrati_ng

Search took 4 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 Filter178691658740.313570897.8
2DLD Change Limit65874783.26320188.2
3Display Results78780.0461695.7
 (SQL Overall)178691783.62249334.9
 
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.