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

193 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
unrolls79779(None) 
enrolls7108091enrolls
unroll61210071unroll_
drolls75312392_drolls
enroll61110072enroll_
enrols61213382enro_ls
knolls10367412kn_olls
outrolls847822outrolls
rerolls739942rerolls
rolls55326232__rolls
scrolls938062scrolls
strolls739182strolls
trolls64613942_trolls
unbolts9247802unbolts
uncoils979532uncoils
unfolds11146802unfolds
unmolds10135742unmolds
unreels7258312unreels
unrobes9269732unrobes
unrolled9610412unrolled
unroofs1035782unroofs
unroots738562unroots
unsells73210772unsells
anoles64827433an_oles
atolls65511353_atolls
bankrolls1543003bankrolls
bedrolls1144673bedrolls
bolls75531313__bolls
brills84916293_brills
broils84114173_broils
brolly114510853_brolly
carols85124983caro_ls
carolus94612603carolus
corolla938623corolla
corollas1039213corollas
dolls66126923__dolls
drills74414203_drills
droll65415403_droll_
drolly105411673_drolly
drools74412813_drools
drumrolls1251463drumrolls
enfolds11136253enfolds
enols54718403en_o_ls
enrobes92211113enrobes
enrol51014283enro_l_
enrolled967963enrolled
enrollee878343enrollee
enrollees974323enrollees
enroller867183enroller
enrollers976173enrollers
enroots738713enroots
enscrolls1192523enscrolls
ensouls736033ensouls
entoils7810733entoils
extolls1444603extolls
frills94414223_frills
girolle835793girolle
girolles935523girolles
grills74314803_grills
growls104711113_growls
gunrooms1144323gunrooms
indoles83716363indoles
indols74714203indo_ls
infalls1038943infalls
infolds11137023infolds
inroads837043inroads
inscrolls11112483inscrolls
insoles73516243insoles
insouls737213insouls
inwalls1037283inwalls
knells10439253kn_ells
knoll9389603kn_oll_
knolly13336133kn_olly
krills104211283_krills
logrolls943373logrolls
lolls512121733__lolls
molls75129783__molls
nerolis71012773nerolis
nerols6914883nero_ls
nills54926673_n_ills
noels56418703_n_oels
noils55024333_n_oils
nolos54423353_n_olos
nulls55019983_n_ulls
nurls55519683nur__ls
outpolls1046213outpolls
outroll749303outroll_
paroles95025883paroles
parols84722613paro_ls
payrolls1344753payrolls
polls74627723__polls
prills84015613_prills
proles84627203_proles
prowls115511083_prowls
pyrolas1239863pyrolas
quolls15327303_quolls
reenrolls942993reenrolls
repolls939053repolls
reroll6412683reroll_
rills55032713__rills
roils54826793__roils
roles56747983__roles
rolfs84817123__rolfs
roll46331653__roll_
rotls55620163__rotls
scroll8310173scroll_
shrills10389933shrills
snells64614203sn_ells
snools65715883sn_ools
stroll6311603stroll_
sunroofs1144763sunroofs
sunrooms1045723sunrooms
thralls10299043thralls
thrills10398783thrills
tolls54728433__tolls
trills64319853_trills
troll54416533_troll_
trolly94012363_trolly
trulls64110283_trulls
unbales92914863unbales
unbelts9237663unbelts
unbolt83013893unbo_lt
unboxes16208303unboxes
uncials92510523uncials
uncles8317163un_cles
unclogs1036803unclogs
uncocks1537233uncocks
uncoil8811853uncoil_
uncool8610113uncool_
uncorks1337443uncorks
uncos74117033unco__s
uncross938193uncro_ss
uncrowns1344363uncrowns
uncurls937123uncurls
undocks1436163undocks
undoers82910583undoers
undoes73917403undo_es
unfold10179703unfo_ld
unfrocks1753843unfrocks
unfurls1035573unfurls
ungodly1244473ungodly
unhelms1234223unhelms
unholily1444133unholily
unholy1238163unho_ly
unhoods1137503unhoods
unhooks1436413unhooks
unions64216753unio_ns
unloads8278523unloads
unlocks1337063unlocks
unmold9148313unmo_ld
unmoors945903unmoors
unnails738223unnails
unpiles92112783unpiles
unpolled1168943unpolled
unravels1144633unravels
unreal64414453unreal_
unreally1148233unreally
unreel63612933unreel_
unrests7229463unrests
unrigs7159003unr_igs
unrips8199453unr_ips
unrobe82611673unro_be
unrobed102711213unrobed
unrolling1078563unrolling
unroof9410193unro_of
unroot6315553unro_ot
unroped102812103unroped
unrough11105233unrough
unround8138503unround
unrounds9145573unrounds
unrove92511683unro_ve
unroven10238143unroven
unruled8311373unruled
unruly938083unr_uly
unseals73212573unseals
unsell63512543unsell_
unshells1145923unshells
unsold71410513unso_ld
unsolid8138373unsolid
unspools1043693unspools
untold7149683unto_ld
unveils1045753unveils
unwell9349443unwell_
unyokes1466733unyokes
upboils1184703upboils
upcoils1184933upcoils
upfolds13133753upfolds
uphills1295233uphills
upholds13135243upholds
uproars986453uproars
uproots937143uproots
upwells12244303upwells
urials64415193u_rials

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271936.31321230.3
3Display Results1931930.0633063.5
 (SQL Overall)1786911936.76626410.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.