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

260 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
uncoil881185(None) 
uncoils979531uncoils
uncool8610111uncool
upcoil10126191upcoil
coil66439652__coil
entoil6912492entoil
noil46133242_n_oil
recoil84016722recoil
unchic1338642unchic
unci65019462unc_i_
uncia75015162unc_ia
uncial83715222uncial
uncivil1244792uncivil
unclip1046992unclip
unco66021402unco__
uncock1438562uncock
uncoiled112512682uncoiled
uncomic1346922uncomic
uncork1239042uncork
uncos74117032unco_s
uncoy104111412unco_y
uncurl839412uncurl
unnail6410582unnail
unroll61210072unroll
until53517742un_til
unveil957342unveil
upboil1096452upboil
upcoils1184932upcoils
aboil72217543_aboil
ancon75718233anco_n
anconal939423anconal
ancone83916953ancone
anil46437433an__il
anvil82712603an_vil
archil11611573archil
assoil688543assoil
boil66335183__boil
broil74918223_broil
bunchily1844543bunchily
bunco94616083bunco__
buncoed12378443buncoed
buncoing13337813buncoing
buncos104011593bunco_s
ceil65725063__ceil
coal66939253__coal
coif96337903__coif
coils75030083__coils
coin66645353__coin
coir66327243__coir
col59360353__co_l
cool66940493__cool
council1137463counc_il
cowl97530813__cowl
dacoit9415443dacoit
encode9310443encode
encomia1147983encomia
encore8314773encore
enjoin1357833enjoin
enol45823823en_o_l
enrol51014283enro_l
enroll61110073enroll
ensoul638253ensoul
entail61114343entail
entoils7810733entoils
envoi878023envoi_
envois988703envois
foil76433913__foil
fucoid1237893fucoid
fungoid1245243fungoid
gumboil1244373gumboil
incivil1244933incivil
inclip1036823inclip
incog838253inco_g
incogs937903incogs
income10712093income
incony1139073incony
indol63714873indo_l
insoul638463insoul
instil61111383instil
junco144612203junco__
juncoes16338073juncoes
juncos15449233junco_s
knoll9389603kn_oll
moil65534083__moil
mucoid1139773mucoid
nail45838653_n_ail
naoi46024633_naoi_
nicol71113293nico_l
nihil8410283_nihil
nil36144193_n__il
noel45226553_n_oel
noils55024333_n_oils
noily86120993_n_oily
noir46722433_n_oir
nuchal11218873nuchal
nuncio837973nunc_io
nuncios937113nuncios
oil37452053___oil
orchil1158653orchil
pencil103712973penc_il
punchily1844863punchily
reboil83814683reboil
recoal84117973recoal
recoils93814873recoils
recoin84320293recoin
reoil55321183_reoil
roil46235293__roil
scowl1012012973_scowl
snail57020203sn_ail
snool55118643sn_ool
soil46138823__soil
spoil75818643_spoil
subcool1146233subcool
subsoil967293subsoil
tinfoil1044623tinfoil
toil46536283__toil
turmoil944723turmoil
unagile838283unagile
unai44824783un_ai_
unais53420773un_ais
unakin10310963unakin
unbid83214633un_bid
unboiled112410373unboiled
unbolt83013893unbolt
unborn83310813unborn
unbox1438753unbo_x
unbuild1035723unbuild
unbuilt948003unbuilt
uncage93014873uncage
uncake122813523uncake
uncap9312283unc_ap
uncaps1039813uncaps
uncase83817433uncase
uncast84215713uncast
unchain1238943unchain
unchair1236163unchair
unchicly1843883unchicly
unchoke16248193unchoke
unciae83215313unciae
uncials92510523uncials
uncinal959963uncinal
uncini8310153uncini
unclad938913unclad
uncle7317053unc_le
uncles8317163uncles
unclips1136433unclips
uncloak1365473uncloak
unclog956603unclog
unclogs1036803unclogs
unclose91111643unclose
uncloud1046433uncloud
uncocks1537233uncocks
uncoded11312743uncoded
uncoffin1643083uncoffin
uncoiling1238993uncoiling
uncoined111813023uncoined
uncomely1545363uncomely
uncooled112710633uncooled
uncorks1337443uncorks
uncouple1245753uncouple
uncouth1247173uncouth
uncover1239003uncover
uncross938193uncross
uncrown1236323uncrown
unction9310663unction
uncuff1436113uncuff
uncurb1037043uncurb
uncurls937123uncurls
uncus74014983unc_us
uncut73219173unc_ut
uncute82912133uncute
undid72415363un_did
undo55620153undo__
undocile1145953undocile
undock1337703undock
undoer73113043undoer
undoes73917403undoes
undoing9312243undoing
undone7914253undone
unfair936233unfair
unfit84518563un_fit
unfix15429033un_fix
unfoiled12249723unfoiled
unfold10179703unfold
unfond10149113unfond
unfurl937953unfurl
ungodly1244473ungodly
ungot61718063ungo_t
ungual738183ungual
unguis738443unguis
unhair937333unhair
unhip10178823un_hip
unholily1444133unholily
unholy1238163unholy
unhood1039233unhood
unhook1347523unhook
unicorn946513unicorn
unific1137463unific
union54519793unio_n
unions64216753unions
unit45140073un__it
unjoint1449233unjoint
unknit1068593unknit
unlaid7311753unlaid
unlit55025463un_lit
unload73010803unload
unlock1248533unlock
unmix14388973un_mix
unmold9148313unmold
unmoor836313unmoor
unmoral948693unmoral
unmown11296093unmown
unnails738223unnails
unnoisy1044243unnoisy
unoiled82415473un_oiled
unpaid939473unpaid
unpile81914323un_pile
unpin72613243un_pin
unreal64414453unreal
unreel63612933unreel
unrig61711413un_rig
unrip72012863un_rip
unrobe82611673unrobe
unrolls797793unrolls
unroof9410193unroof
unroot6315553unroot
unrove92511683unrove
unsaid7411833unsaid
unseal63315473unseal
unsell63512543unsell
unship1148033unship
unsocial1046073unsocial
unsoiled92412073unsoiled
unsold71410513unsold
unsolid8138373unsolid
unsown9328433unsown
unspilt938853unspilt
unspoilt1044883unspoilt
unspool945163unspool
untie54425493un_tie
unto45824283unto__
untold7149683untold
untorn63012343untorn
untrim8310673untrim
unveils1045753unveils
unvocal1245233unvocal
unvoice12126153unvoice
unwell9349443unwell
unwit84417523un_wit
unwon84512343unwo_n
unworn93411333unworn
unwove12238883unwove
unyoke1367293unyoke
unzip16207623un_zip
upboils1184703upboils
upcoiled13215183upcoiled
upcurl1034963upcurl
uracil8311543uracil
urchin1138743urchin
zincoid1946663zincoid

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.1731032896.0
2DLD Change Limit1127162606.67016899.0
3Display Results2602600.0803250.0
 (SQL Overall)1786912606.92325811.2
 
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.