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

105 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
unfolder1221658(None) 
enfolder1286151enfolder
infolder1256431infolder
unfolded1338311unfolded
unfolders1344721unfolders
unsolder937211unsolder
enfolded1345432enfolded
enfolders1395092enfolders
folder104317542__folder
infolded1375662infolded
infolders1385172infolders
inholder1276112inholder
unfold10179702unfold__
unfolds11146802unfold_s
unholier1137282unholier
unloader936642unloader
unmolded1237452unmolded
unsolders1064692unsolders
upfolded1542882upfolded
upholder1444082upholder
beholder1435053beholder
bolder94820933__bolder
coholder1436073coholder
colder95121853__colder
encoder1038633enco_der
enfold10137613enfold__
enfolds11136253enfold_s
enforcer13246503enforcer
enroller867183enroller
fanfolded1742313fanfolded
fodder114712113__fodder
folded114212793__folded
folders113514393__folders
fonder104120063__fonder
golder84417603__golder
gunpowder1641323gunpowder
holder104619653__holder
infielder1343173infielder
infold10128163infold__
infolds11137023infold_s
informer13227283informer
inholders1345353inholders
involver1444663involver
knoller11285913kn_oller
molder93819273__molder
nodder84811943_n_odder
older65121173___older
penholder1544413penholder
pinfolded1643333pinfolded
polder94019253__polder
refolded1337063refolded
resolder9259233resolder
scolder103210343_scolder
smolder10327753_smolder
solder73921343__solder
sunflower1563553sunflower
unbolted1179323unbolted
unbonded12299763unbonded
uncoded11312743unco_ded
uncover1239003unco_ver
under64624213un___der
undoer73113043undo__er
unfaded123111733unf_aded
unfairer11184283unfairer
unfallen1144463unfallen
unfelted1279403unfelted
unfetter1136753unfetter
unfilled1298383unfilled
unfilmed1495803unfilmed
unfoiled12249723unfoiled
unfolding1436063unfolding
unfoldment1653593unfoldment
unfond10149113unfond__
unforced14239133unforced
unforged13238623unforged
unforked16218953unforked
unformed14239573unformed
unfounded1435363unfounded
unfunded1336473unfunded
ungelded1147403ungelded
ungodlier1152403ungodlier
unhooded13277873unhooded
uniformer1443633uniformer
unkinder1335363unkinder
unkosher1573763unkosher
unloaded1049533unloaded
unloaders1044403unloaders
unmold9148313unmold__
unmolds10135743unmold_s
unmolten1044933unmolten
unpolled1168943unpolled
unrolled9610413unrolled
unrulier845333unrulier
unsober967643unso_ber
unsold71410513unsold__
unsoldered1243583unsoldered
unsolved1237833unsolved
unsounder1044373unsounder
untold7149683untold__
unwelded1337143unwelded
unwinder1235613unwinder
unwooded13207443unwooded
upfold12124953upfold__
upfolds13133753upfold_s
upholders1543643upholders

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621056.58022213.1
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.03225411.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.