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

102 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
unsolder93721(None) 
unfolder12216581unfolder
unsolders1064691unsolders
enfolder1286152enfolder
infolder1256432infolder
inholder1276112inholder
resolder9259232resolder
solder73921342__solder
unfolded1338312unfolded
unfolders1344722unfolders
unholier1137282unholier
unloader936642unloader
unmolded1237452unmolded
unsober967642unso_ber
unsold71410512unsold__
unsoldered1243582unsoldered
unsolved1237832unsolved
unsounder1044372unsounder
upholder1444082upholder
absolver1343693absolver
beholder1435053beholder
bolder94820933__bolder
coholder1436073coholder
colder95121853__colder
consoler102812613consol_er
disorder1038133disorder
encoder1038633enco_der
enfolded1345433enfolded
enfolders1395093enfolders
enroller867183enroller
folder104317543__folder
gasholder1443823gasholder
gasolier935833gasolier
golder84417603__golder
gunpowder1641323gunpowder
holder104619653__holder
infolded1375663infolded
infolders1385173infolders
inholders1345353inholders
insider849733ins_ider
insole63515863insol_e_
insoles73516243insol_es
insulter836883insulter
involver1444663involver
knoller11285913kn_oller
misorder1147283misorder
molder93819273__molder
nodder84811943_n_odder
older65121173___older
penholder1544413penholder
polder94019253__polder
resolders10258013resolders
resolver11339793resolver
scolder103210343_scolder
smolder10327753_smolder
solders83517773__solders
soldier82812153__soldier
solider82912453__solider
solver94016703__solver
sonder73623523__sonder
unbolted1179323unbolted
unbonded12299763unbonded
uncoded11312743unco_ded
uncover1239003unco_ver
under64624213un___der
undoer73113043undo__er
unfold10179703unfold__
unfolds11146803unfold_s
ungelded1147403ungelded
ungodlier1152403ungodlier
unhooded13277873unhooded
unkinder1335363unkinder
unkosher1573763unkosher
unloaded1049533unloaded
unloaders1044403unloaders
unmold9148313unmold__
unmolds10135743unmold_s
unmolten1044933unmolten
unpolled1168943unpolled
unrolled9610413unrolled
unrulier845333unrulier
unsalted9510923unsalted
unseeded1038253unseeded
unshaded13149263unshaded
unsicker1435303unsicker
unsoaked1338853unsoaked
unsoiled92412083unsoiled
unsoldering1342673unsoldering
unsoldierly1551203unsoldierly
unsolid8138373unsol_id
unsorted9312513unsorted
unsounded1135543unsounded
unsoured9310063unsoured
unsowed112511053unso_wed
unstopper1343523unstopper
unswollen1242623unswollen
untold7149683untold__
unwelded1337143unwelded
unwinder1235613unwinder
unwooded13207443unwooded
upfolded1542883upfolded
upholders1543643upholders

Search took 7 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621026.34323043.0
3Display Results1021020.0303400.0
 (SQL Overall)1786911026.79626293.6
 
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.