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

232 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
unroll6121007(None) 
enroll61110071enroll
unrolls797791unrolls
droll65415402_droll
enrol51014282enro_l
enrolls7108092enrolls
enrols61213382enrols
knoll9389602kn_oll
outroll749302outroll
reroll6412682reroll
roll46331652__roll
scroll8310162scroll
stroll6311602stroll
troll54416532_troll
unbolt83013892unbolt
uncoil8811852uncoil
uncool8610112uncool
unfold10179702unfold
unholy1238162unholy
unmold9148312unmold
unreal64414452unreal
unreel63612932unreel
unrobe82611672unrobe
unrolled9610412unrolled
unroof9410192unroof
unroot6315552unroot
unrove92511682unrove
unruly938082unruly
unsell63512542unsell
unsold71410512unsold
untold7149682untold
unwell9349442unwell
anole55330373an_ole
antiroll847763antiroll
atoll57913923_atoll
bankroll1443493bankroll
bedroll1055553bedroll
boll65634753__boll
brill74819953_brill
broil74918223_broil
brolly114510853_brolly
carol75128613caro_l
caroli85918233caroli
carols85124983carols
corolla938623corolla
doll56632493__doll
drill64718263_drill
drolls75312393_drolls
drolly105411673_drolly
drool65416103_drool
drumroll1141773drumroll
enfold10137613enfold
enol45823823en_o_l
enols54718403en_ols
enrobe86610793enrobe
enrolled967963enrolled
enrollee878343enrollee
enroller867183enroller
enroot6615993enroot
enscroll1093333enscroll
ensoul638253ensoul
entoil6912493entoil
extoll1334863extoll
frill84917563_frill
girolle835793girolle
grill64617893_grill
growl96115823_growl
gunroom1045053gunroom
indol63714873indo_l
indole74516053indole
indols74714203indols
infall939403infall
infill938403infill
infold10128163infold
inro45920793inro__
inroad737933inroad
inscroll10113213inscroll
insole63515863insole
insoul638463insoul
inwall938343inwall
knell94210923kn_ell
knolls10367413kn_olls
knolly13336133kn_olly
krill94213643_krill
logroll844263logroll
loll46128383__loll
moll66735703__moll
nerol51017813nero_l
neroli61111153neroli
nerols6914883nerols
nill45634303_n_ill
noel45226553_n_oel
noil46133243_n_oil
nolo46229313_n_olo
null45125313_n_ull
nurl45327243nur__l
nurls55519683nur_ls
outpoll946793outpoll
outrolls847823outrolls
parol74826273paro_l
parole84425253parole
parols84722613parols
payroll1245613payroll
poll66332133__poll
prill74117943_prill
prole74527793_prole
prowl105615123_prowl
pyrola1139003pyrola
quoll14379493_quoll
reenroll843543reenroll
repoll8410793repoll
rerolls739943rerolls
rill45140903__rill
roil46235293__roil
role45851823__role
rolf75134873__rolf
rolls55326233__rolls
rotl45029683__rotl
scrolls938063scrolls
shrill94712303shrill
snell54517303sn_ell
snool55118643sn_ool
snools65715873snools
strolls739183strolls
sunroof1047053sunroof
sunroom947013sunroom
thrall93810293thrall
thrill94910593thrill
toll45535263__toll
trill55122933_trill
trolls64613943_trolls
trolly94012353_trolly
trull54012673_trull
unable83819223unable
unbale83616403unbale
unbelt83015693unbelt
unbolts9247803unbolts
unborn83310813unborn
unbox1438753unbo_x
unbroke13217743unbroke
uncial83715223uncial
uncle7317053un_cle
unclog956603unclog
unco66021403unco__
uncock1438563uncock
uncoils979533uncoils
uncork1239043uncork
uncos74117033unco_s
uncoy104111413unco_y
uncross938193uncross
uncrown1236323uncrown
uncurl839413uncurl
undo55620153undo__
undock1337703undock
undoer73113043undoer
undoes73917403undoes
undone7914253undone
unduly1037823unduly
unfelt92413463unfelt
unfolds11146803unfolds
unfond10149113unfond
unfrock1674633unfrock
unfroze1945413unfroze
unfurl937953unfurl
ungodly1244473ungodly
ungot61718063ungo_t
ungual738183ungual
ungula737603ungula
unhelm1136863unhelm
unholily1444133unholily
unhood1039233unhood
unhook1347523unhook
union54519793unio_n
unions64216753unions
unload73010803unload
unlock1248533unlock
unmolds10135743unmolds
unmoor836313unmoor
unmoral948693unmoral
unmown11296093unmown
unnail6410583unnail
unpile81914323unpile
unpolled1168943unpolled
unravel1038063unravel
unread73412673unread
unreally1148223unreally
unreels7258313unreels
unrent63219783unrent
unrest62918853unrest
unrig61711413unr_ig
unrigs7159003unrigs
unrip72012863unr_ip
unripe82012093unripe
unrips8199453unrips
unrobed102711213unrobed
unrobes9269733unrobes
unrolling1078563unrolling
unroofs1035783unroofs
unroots738563unroots
unroped102812103unroped
unrough11105233unrough
unround8138503unround
unroven10238143unroven
unruled8311373unruled
unseal63315473unseal
unsells73210773unsells
unshell1047113unshell
unsolid8138373unsolid
unsown9328433unsown
unspool945163unspool
until53517743un_til
unto45824283unto__
untorn63012343untorn
untrod769853untro_d
untruly1046293untruly
unveil957343unveil
unvocal1245233unvocal
unwon84512343unwo_n
unworn93411333unworn
unwove12238883unwove
unyoke1367293unyoke
upboil1096453upboil
upcoil10126193upcoil
upfold12124953upfold
uphill11106173uphill
uphold12126903uphold
uproar8106933uproar
uproot8314123uproot
uprose82311483uprose
upwell11285793upwell
ureal56722683u_real
urial54823023u_rial

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127162326.25018034.6
3Display Results2322320.0763052.6
 (SQL Overall)1786912326.46927622.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.