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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
solifluctions1810114(None) 
solifluction1761251solifluction_
collections1547934col__lections
conflictions1945224co_nflictions
olfactions1563874_ol_f_actions
pollutions1245434pol__lu_tions
solicitations1544894solicitations
solutions988884so___lu_tions
afflictions1943405__afflictions
bilections14136505__bi_lections
bolections14137295bo___lections
coalifications2155705coalifications
codifications21127625codifications
codirections1744705codi_rections
coevolutions1754085coevolu_tions
cofunctions1845015co__functions
collations12312855col__l_ations
collection1448205col__lection_
collocations1646405col__locations
collusions1245975col__lu_sions
conductions1649665co__nductions
confections18411395co_nf_ections
conflations16411145co_nfl_ations
confliction1845235co_nfliction_
constructions1747715constructions
convolutions1745195convolu_tions
coproductions2054495coproductions
deflections17187325__deflections
dilutions10248585__di_lu_tions
flections14239215____flections
foliations1399945foli___ations
genuflections1951515genuflections
inductions1348805___inductions
inflections1646995__inflections
inflictions1645445__inflictions
jollifications26144595jollifications
liposuctions1662035__liposuctions
liquations1945625__li_quations
malefactions1953145malef_actions
malfunctions1952665mal_functions
modifications21106985modifications
mollifications21145205mollifications
nonelections1456395no_nelections
nonfictions1645935no_nf_ictions
nonsolutions1254175nonsolu_tions
notifications1848235notifications
obstructions16155525_obstructions
olfaction1464235_ol_f_action_
oscillations1445125osci_llations
ossifications18176145ossifications
pollution1146005pol__lu_tion_
proliferations1952705proliferations
reflections16178555__reflections
relictions12310025reli___ctions
salinizations2258425salinizations
salivations1448735sali__vations
satisfactions18141915satisfactions
seductions1366875s___eductions
selections12310875s___elections
sibilations13127935sibi_l_ations
siltations1038555s__i_ltations
simulations1368395s__imulations
sinuations1039415s__i_nuations
situations1038435s__i_tuations
socializations2548485socializations
solarizations22219275solarizations
solations9814625so___l_ations
solicitation1445365solicitation_
solicitors1244215soli___citors
solicitous1244175soli___citous
solidifications2153575solidifications
solitons849595soli____t_ons
solmizations2346635sol_mizations
solution889595so___lu_tion_
solvations1336835so___lvations
sonications1349955soni__cations
spiculations1646175s_piculations
spoliations1347695spoli___ations
stagflations1652865stagfl_ations
stictions1148355s_ti___ctions
stimulations1456205s_timulations
stipulations1455445s_tipulations
strictions1249145stri___ctions
stridulations1454405stridulations
subductions1644505s__ubductions
suctions103012905s_____uctions
sulfations13107815sul_f__ations
sulfonations1543925sul_fonations
uglifications1945195uglifications
vilifications2166745vilifications
vociferations2153115vociferations
volitions1288665voli____tions
volutions12108395vo___lu_tions

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.390458182.1
2DLD Change Limit124790938.11015387.2
3Display Results93930.0631476.2
 (SQL Overall)178691938.56320867.8
 
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.