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

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

138 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
solutions98888(None) 
solations9814621solations
solution889591solution_
volutions12108391volutions
ablutions1146602ablutions
absolutions1344712absolutions
dilutions10248582dilutions
elutions82513052_elutions
evolutions13107042evolutions
exsolutions1844012exsolutions
isolations10310692isolations
locutions11207062locutions
pollutions1245432pollutions
resolutions11117792resolutions
solation8916152solation_
solions7513752sol__ions
solitons849592solit_ons
solvations1336832solvations
sorptions1137122sorptions
volitions1288662volitions
volutins1188002voluti_ns
volution1198602volution_
ablations11311513ablations
ablution1047223ablution_
abolitions1246653abolitions
absolution1244403absolution_
alations82518893_alations
allusions946013allusions
alluvions1254373alluvions
bolections14137293bolections
boutons9310783bo_ut_ons
calutrons1145503calutrons
cautions103313183_cautions
coactions1349743coactions
coalitions1247923coalitions
coitions10312853co_itions
collations12312853collations
collusions1245973collusions
conations111318903conations
cooptions13107763cooptions
delations102616593delations
deletions102610933deletions
delusions1037053delusions
desolations12310593desolations
devolutions15106263devolutions
dilations102614453dilations
dilution9239143dilution_
diluvions13224443diluvions
dissolutions13144923dissolutions
donations101112353donations
dotations101411633dotations
elations83719123_elations
elocutions1245963elocutions
elusions82610083_elusions
elution72913823_elution_
evolution12117093evolution_
exsolution1743763exsolution_
fluxions1844423_fluxions
foliations1399943foliations
gelations102513093gelations
gluttons944273_gluttons
halations12312393halations
illations9311393illations
illusions946213illusions
insolations1149183insolations
involutions1445903involutions
iodations1039113iodations
isolation9311643isolation_
lobations11219613lobations
locations112512743locations
locution10227663locution_
lotions74614763__lotions
monitions11310883monitions
motions94215003mo__tions
moutons9410313mo_ut_ons
nonsolutions1254173nonsolutions
nonunions945583nonunions
notations91512973notations
notions74014483no__tions
novations12139003novations
oblations1139373oblations
options93810603_o_ptions
orations81515803_orations
ovations11149263_ovations
plutons938343_plut_ons
pollution1146003pollution_
portions10514413po_rtions
positions11811503positions
potations111615073potations
potions93417423po__tions
prolusions1245883prolusions
relations92418333relations
resolution1097733resolution_
revolutions1497633revolutions
rogations101510823rogations
rotations91613843rotations
saltations10310623saltations
salutations1147643salutations
saluting9310553saluti_ng
salvations1338133salvations
sanctions1138873sanctions
scalations1239783scalations
scullions1154683scullions
seclusions1244633seclusions
sections102714703s_ections
sedations10311253sedations
seditions1039013seditions
seductions1366873seductions
selections12310873selections
siltations1038553siltations
sinuations1039413sinuations
situations1038433situations
solanins8310513solani_ns
solating9315593solati_ng
solion6616383sol__ion_
soliton7410233solit_on_
solons65120023sol___ons
solstices1146703solstices
solutes73515263solut__es
solvation1237773solvation_
sorption1037513sorption_
sortitions1046423sortitions
soupcons1244373so_upcons
southrons1245843so_uthrons
spoliations1347693spoliations
stations82415223s_tations
stictions1148353stictions
sublations12410113sublations
suctions103012903s_uctions
sudations1039903sudations
sulcations1289583sulcations
sulfations13107813sulfations
valuations1348783valuations
violations1337963violations
vocations141911423vocations
volition1179173volition_
volutin1098103voluti_n_
zonations18139313zonations

Search took 8 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411386.73322076.5
3Display Results1381380.0632190.5
 (SQL Overall)1786911387.21924752.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.