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

147 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
unrolling107856(None) 
enrolling1087731enrolling
carolling1259412carolling
drolling103510762_drolling
knolling13206892kn_olling
outrolling1137532outrolling
rerolling102210372rerolling
rolling83620412__rolling
scrolling12187802scrolling
strolling10238792strolling
trolling93212492_trolling
unbolting1236452unbolting
uncoiling1238992uncoiling
unfolding1436062unfolding
unmolding1335822unmolding
unreeling1038982unreeling
unrobing1138062unro_bing
unroofing1385702unroofing
unrooting1098832unrooting
unselling10810332unselling
unwilling1337162unwilling
annulling1045003annulling
anvilling1336833anvilling
bankrolling1852303bankrolling
bolling103820883__bolling
broiling113112013_broiling
caroling113317003caro_ling
controlling1445423controlling
dolling93817373__dolling
drilling103311983_drilling
drooling102610423_drooling
enfolding1444833enfolding
ennobling1244123ennobling
enrobing1137433enro_bing
enrooting10128133enrooting
enscrolling1452283enscrolling
ensouling1046003ensouling
entoiling1038483entoiling
extolling1744623extolling
frilling123011493_frilling
funnelling1444243funnelling
grilling103811533_grilling
growling1348163_growling
infalling1356243infalling
infolding1445413infolding
inholding1445113inholding
inscrolling1452443inscrolling
insouling1036823insouling
involving1644363involving
inwalling1385633inwalling
knelling13319023kn_elling
logrolling1243063logrolling
lolling83415773__lolling
nilling83619563_n_illing
noodling10209443_noodling
nulling83818063_n_ulling
nurling84215823nur__ling
nursling997603nur_sling
outpolling1346213outpolling
paroling113316213paro_ling
patrolling1345693patrolling
perilling12410003perilling
polling102920383__polling
prilling113413413_prilling
prowling1449993_prowling
reenrolling1242703reenrolling
repolling122110203repolling
rilling84023623__rilling
roiling83220453__roiling
rolfing113710653__rolfing
rollings9419953__rollings
shrilling13307693shrilling
snelling93913563sn_elling
snooling93013473sn_ooling
snoozling19314343snoozling
thralling13256833thralling
thrilling13276693thrilling
tolling83418563__tolling
trilling92815963_trilling
trollings10286693_trollings
trollying1354053_trollying
tunnelling1144383tunnelling
unbaling11310683un_baling
unbelting1237663unbelting
unbottling1343133unbottling
unbowing1436993unbo_wing
unboxing1836113unbo_xing
unbridling1443903unbridling
unclosing1247753unclosing
uncloying1555813uncloying
uncoating12611923uncoating
uncocking1836233uncocking
uncorking1637403uncorking
uncoupling1544463uncoupling
uncrossing1345203uncrossing
uncrowning1644273uncrowning
uncurling1237113uncurling
underling111514613underling
undocking1735653undocking
undoing9312243undo__ing
undoubling14133433undoubling
unfailing1337453unfailing
unfeeling1337113unfeeling
unfrocking2043533unfrocking
unfurling1335763unfurling
ungloving1444713ungloving
ungluing1035863un_gluing
unhelming1535493unhelming
unhooding1435893unhooding
unhooking1735353unhooking
unhorsing1336853unhorsing
unhousing1335883unhousing
unloading1137193unloading
unlocking1636073unlocking
unloosing1036113unloosing
unloving1277483unlo_ving
unmooring1255813unmooring
unmoving1436253unmo_ving
unnailing1037023unnailing
unpeopling1543223unpeopling
unpiling1139753un_piling
unraveling1454473unraveling
unravelling1543153unravelling
unreeving1336213unreeving
unresting10311133unresting
unriddling1342633unriddling
unrigging1245183unrigging
unripping1434643unripping
unroll61210073unroll___
unrolled9610413unroll_ed
unrolls797793unroll__s
unrounding1244873unrounding
unsealing10711043unsealing
unshelling1445593unshelling
unsling8313643un__sling
unsmiling1256873unsmiling
unspooling1343853unspooling
unveiling1337723unveiling
unvoicing1545083unvoicing
unyoking1636183unyo_king
upboiling1444633upboiling
upcoiling1444793upcoiling
upfolding1642943upfolding
upholding1643373upholding
uprooting1276903uprooting
uprousing1235623uprousing
upwelling1535233upwelling

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.403443402.0
2DLD Change Limit1486411477.20620627.4
3Display Results1471470.0761934.2
 (SQL Overall)1786911477.68523251.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.