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

88 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
compellations195481(None) 
compellation1855101compellation_
compensations19136182compensations
compilations1848682comp_ilations
complexations26134012complexations
cupellations1643802c_upellations
appellations1643533_appellations
cancellations1754393cancellations
collations12312853co___llations
commendations2055803commendations
compensation18126503compensation_
competitions1845533compe_titions
compilation1749313comp_ilation_
completions1746913comp__letions
complexation25144243complexation_
complications2147433complications
compurgations20123893compurgations
computations1848123comp_utations
congelations1549733conge_lations
constellations1654403constellations
cooperations1659193coope_rations
copulations151111113co_p_ulations
correlations1447863corre_lations
crenellations1553573crenellations
cupellation1544143c_upellation_
appellation1564124_appellation_
cancelations1657094cance_lations
cancellation1655014cancellation_
cantillations1545734cantillations
cementations1659014cem_entations
chelations1539074c__he_lations
coacervations2053874coacervations
coagulations1546514co_agulations
coaptations1547544coap__tations
collation11313994co___llation_
combinations1897924com_binations
commemorations1953444commemorations
commendation1946514commendation_
comminations18810484com_minations
commutations1847264com_mutations
compactions1946544comp__actions
companions1697264comp___anions
compelling1746554compell__i_ng
compensating1955004compensati_ng
compensational2073524compensational
compensators1854374compensat_ors
competition1755774compe_tition_
complains1549194comp__la_i_ns
completion1647304comp__letion_
complexions2443624comp__lexions
complication2048204complication_
compositions1846254comp_ositions
compulsions1744594comp_ul_sions
compunctions20145694comp_unctions
compurgation19134184compurgation_
computation1748714comp_utation_
conciliations1747204conciliations
condemnations1845404condemnations
condensations1646274condensations
conflations16411144co__nflations
congelation14410344conge_lation_
consecrations1749214consecrations
conservations1849094conservations
consolations1449744co_nsolations
constellation1554794constellation_
consultations1546934consultations
contemplations2074734contemplations
contestations1547734contestations
conversations1847454conversations
cooperation15410024coope_ration_
copulation141111954co_p_ulation_
corporations16129484corp_orations
correlation1358554corre_lation_
crenelations1446184crene_lations
crenellation1453914crenellation_
cumulations1547434cum__ulations
decompensations22103044decompensations
fellations1338064___fellations
flagellations1752234flagellations
fomentations1746794fom_entations
impetrations1645444_impetrations
operations12312954_o_pe_rations
oscillations1445114_oscillations
peltations12311554___peltations
populations15148714po_p_ulations
recompilations2054954recomp_ilations
spallations1356104__spallations
tessellations1352614tessellations

Search took 6 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.360496363.9
2DLD Change Limit95024884.93619251.2
3Display Results88880.0631396.8
 (SQL Overall)178691885.35933344.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.