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

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

107 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
recognitions154485(None) 
precognitions1853591precognitions
recognition1445201recognition_
cognitions1346042__cognitions
precognition1753882precognition_
reconditions1546822reconditions
reignitions1244552re_ignitions
cognations1339593__cognations
cognition1247013__cognition_
deconditions1645283deconditions
nonrecognitions1871223nonrecognitions
preconditions1854893preconditions
preignitions1554003pre_ignitions
premonitions1646853premo_nitions
recognising1544543recognisi_ng
recognizing2445693recognizi_ng
recondition1447123recondition_
reconnections1765753reconnections
reconvictions2054873reconvictions
recordations1548643recordations
reignition1144893re_ignition_
repositions131110163repo_sitions
resignations1346883resignations
admonitions1444244admo_nitions
coalitions1247924__coalitions
cognation12310754__cognation_
cognitional1454274__cognitional
coitions10312854__co__itions
conations111318904__co_nations
conditions13410104__conditions
connations12312944__connations
conniptions1546034__conniptions
declinations15410224declinations
decoctions1547144deco__ctions
decollations1547364decollations
decondition1545414decondition_
decongestions1753564decongestions
decorations14312884deco_rations
definitions1545604de_finitions
demolitions1446524demo_litions
depositions14117684depo_sitions
derogations1349394derog_ations
designations1456944designations
detonations1239374deto_nations
elongations1244664_elongations
ignitions1045804___ignitions
incognitos1352314incognit_o_s
lenitions939474le___nitions
monitions11310884__mo_nitions
nonrecognition1771444nonrecognition_
pectinations1649254pectinations
precognitive2052754precogniti_ve
precondition1755244precondition_
preconvictions2353354preconvictions
preignition1454434pre_ignition_
premonition1547354premo_nition_
premunitions1644984pre_munitions
prepositions16108304prepo_sitions
recantations1448874recantations
recautions1247814rec__autions
recensions1248484rec_en_sions
receptions1449744rec__eptions
recisions1139914rec___isions
recitations13314204rec_itations
reclamations1645714reclamations
recognises1345534recogn__ises
recognizers2353214recogni_zers
recognizes2255574recogn__izes
recollections1754724recollections
recolonizations26165764recolonizations
recombinations2095594recombinations
recommissions1953654recommissions
recompilations2054954recompilations
recompositions2053174recompositions
reconceptions1965124reconceptions
reconditioned1783274reconditioned
reconnection1655994reconnection_
reconsigns1344414reco_n_signs
reconviction1955084reconviction_
recordation1449264recordation_
recounting1339194recoun_ti_ng
recreations13412254rec_reations
redefinitions1752334redefinitions
redigestions1483864redigestions
reeditions1147654re__editions
reformations1747604reformations
refoundations17102634refoundations
reigniting1246374re_igniti_ng
relegations1248974releg_ations
relocations13311144relo_cations
remigrations15227794remigrations
remotions1149704remo___tions
renditions1149184re__nditions
renominations15108304renominations
renovations1448424reno_vations
repartitions1444964repartitions
repetitions1378024re_petitions
reposition121010144repo_sition_
requisitions2153864requisitions
resignation1247474resignation_
resolutions11117794reso_lutions
resorptions1347234reso_rptions
retentions101611114re_ten_tions
retortions1049144reto__rtions
revocations16410314revo_cations
revolutions1497634revo_lutions
rogations101510824r__og_ations

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 Filter1786911247900.393454684.5
2DLD Change Limit1247901077.89015816.2
3Display Results1071070.0601783.3
 (SQL Overall)1786911078.34321418.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.