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

459 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
should103802(None) 
ahold94714252aho_ld
could86517712_could
ghoul959052ghoul_
ghouls1036042ghouls
hold86235062_ho_ld
hound95016482_hound
mould86015752_mould
scold85414862sco_ld
shaul85418102shaul_
shauled1148792shauled
shauls94913112shauls
shield106212972shield
shoal83920262shoal_
shoaled113810962shoaled
shoals94215782shoals
shoaly124010762shoaly
shod86225052sho__d
shoed95723002sho_ed
shooed103916072shooed
shool84523142shool_
shooled115212652shooled
shools94919002shools
shored105723642shored
shorl84720242shorl_
shorls94516192shorls
shoulder1234752shoulder
shouldst1243392shouldst
shout85433162shou_t
shouted113911542shouted
shouts94017712shouts
shoved134214272shoved
showed135016962showed
shroud1038762shrou_d
shul75823152sh_ul_
shuln84713112sh_uln
shuls85319712sh_uls
sold54837412s_o_ld
soul46435712s_oul_
souled75419822s_ouled
souls55127362s_ouls
sound64420022s_ound
stound7399902stound
swound10377632swound
thoued10429002thoued
would95513152_would
abound9239863abound
acold86214923aco_ld
afoul8510193afoul_
aholds10469483aho_lds
ahull84010313ah_ull
aloud65018063alou_d
around72712413around
astound845503astound
auld54125363__auld
behold1247343beho_ld
bold75432813_bo_ld
boule74828043_boule
bound84819583_bound
cauld85318443_cauld
chield124610213chield
child114516223ch_ild
choked164914793choked
chola104718033cho_la
cholla113911023cholla
cholo105217973cho_lo
chord115917263cho_rd
chored125321883chored
chough15699243chough
chouse116017563chouse
choused135012463choused
choush14549063choush
chowed154914643chowed
cloud86716423clou_d
cold77338773_co_ld
dhole95215363dho_le
dhooly13457143dhooly
doula65717773_doula
fauld95214493_fauld
fold86528943_fo_ld
foul77027583_foul_
fouled104315973_fouled
fouls87221433_fouls
found94917843_found
ghoulie1144253ghoulie
gold65430163_go_ld
gourd71011903_gourd
ground82310273ground
haul75530453_haul_
hauled104415213_hauled
haulm104415413_haulm
hauls86123733_hauls
held85330403_h_eld
hoard94918313_hoard
hod76852463_ho__d
hodad10311353_hodad
hoed87837983_ho_ed
hoked135326993_hoked
holds94623243_ho_lds
hole77553393_ho_le
holed95634133_holed
holk116027943_ho_lk
holla84918493_holla
hollo84822163_hollo
holly114824433_holly
holm95628103_ho_lm
holp95727553_ho_lp
hols76946293_ho_ls
holt77852583_ho_lt
holy106333433_ho_ly
homed115425423_homed
honed95332263_honed
hood85132333_ho_od
hooly115022223_hooly
hoped115628183_hoped
hosed95830983_hosed
hotly115815473_hotly
hounds104413133_hounds
hour75827313_hou_r
houri85915233_houri
hourly12369623_hourly
hours85422383_hours
house89131423_house
housed105624103_housed
howl107625693_howl_
howled134014963_howled
howls116219223_howls
hoyle11314413_hoyle
hued86925853_h_ued
hula74923753_h_ula
hulk115321613_h_ulk
hull75428783_h_ull
joule124918203_joule
khoum1476633khou_m
khoums1594013khoums
loud55228043_lou_d
meoued9118533meoued
mold76034333_mo_ld
moulds94910993_moulds
mouldy12437413_mouldy
moult74728723_moult
mound83918313_mound
old47033463__o_ld
oud47439073__ou_d
phoned124014553phoned
poult76928873_poult
pound84417863_pound
proud84615483prou_d
round64318433_round
saul45836523s_aul_
sauls55128123s_auls
sault55834963s_ault
scald84818123s_cald
school11410723school_
schooled1447043schooled
schools1249113schools
schorl1179803schorl_
schorls1248353schorls
schul102510413schul_
schuln11256233schuln
schuls11299853schuls
scolds95011233sco_lds
scoped115116653scoped
scopula1154993scopula
scored94621133scored
scour75315533scou_r
scoured103811153scoured
scours84913583scours
scouse84113633scouse
scout75031453scou_t
scouted104112033scouted
scouth115011153scouth
scouts84817943scouts
scowed124413823scowed
scowl1012012973scowl_
scowled13398183scowled
scowls11549593scowls
scud76221283s_cu_d
sculk115112463s_culk
scull75315763s_cull
sculp95314843s_culp
secund937103secund
segued838513segued
shad86230913sh__ad
shaded114518873shaded
shaird10288703shaird
shale85332833sh_ale
shaled105023953shaled
shall85024053sh_all
shalt85534483sh_alt
shaly114322863sh_aly
shamed125120213shamed
shaped125020103shaped
shard96125963sh_ard
shared105829063shared
shaugh13287433shaugh
shaved135118383shaved
shawed134817233shawed
shawl116217573shawl_
shawled1437773shawled
shawls125411973shawls
sheal84927703sheal_
sheals94420643sheals
shed86536153sh__ed
sheila969843sheila
shelf115221113sh_elf
shell84424123sh_ell
shelled113815083shelled
shells94319523shells
shelly124414463shelly
shend94719973sh_end
sheol84318363sheol_
sheols94614153sheols
sherd96321153sh_erd
sheuch14267043sheuch
sheugh13295883sheugh
shewed134716183shewed
shied96125493sh_ied
shiel811023773shiel_
shields11538043shields
shiels95418923shiels
shill85325333sh_ill
shilled113313623shilled
shills94519603shills
shily115222013sh_ily
shined104620783shined
shlub105411743shlu_b
shlubs11386733shlubs
shlump1345713shlump
shmuck1734243shmuck
shoaler102610073shoaler
shoat85633943sho_at
shoats94117073shoats
shock144917023sho_ck
shocked174611803shocked
shocks154414573shocks
shoddy1434533shoddy
shoe75933433sho__e
shoer84722153sho_er
shoers94518323shoers
shoes85429653sho_es
shofar1236303shofar
shog86025133sho__g
shogged13397953shogged
shogi95013993sho_gi
shogis103810923shogis
shogs95319703sho_gs
shogun1045703shogun
shoguns1134413shoguns
shoji15419943sho_ji
shojis16348473shojis
sholom11910093sholom
shone83725973sho_ne
shoo75929883sho__o
shoofly1634343shoofly
shook124920153sho_ok
shooks134515623shooks
shoon84022003sho_on
shoos84226353sho_os
shoot84235893sho_ot
shoots94619343shoots
shop95629833sho__p
shoppe133110313shoppe
shopped153512203shopped
shops104222893sho_ps
shoran94016033shoran
shore85432643sho_re
shores94830403shores
shorn85722173sho_rn
short85040523sho_rt
shorted113614393shorted
shortly13387563shortly
shorts95321733shorts
shorty124313193shorty
shot76150243sho__t
shote85526083sho_te
shotes95321893shotes
shots84730833sho_ts
shott85332173sho_tt
shotted113912383shotted
shotts93614683shotts
shoulders1334223shoulders
shouldest1344143shouldest
shouter103213073shouter
shove114421033sho_ve
shovel124611313shovel
shoveled15195353shoveled
shovels13378383shovels
shover124515983shover
shoves124919413shoves
show106229183sho__w
shower124315103shower
showily1636213showily
shown115216473sho_wn
shows115324573sho_ws
showy145714003sho_wy
shoyu1138903sho_yu
shoyus1265993shoyus
shred98125613sh_red
shrewd136810773shrewd
shrill94712303shrill
shrouded1333593shrouded
shrouds1136013shrouds
shrub104814893shru_b
shrubs11409213shrubs
shrug94512513shru_g
shrugs10469163shrugs
shrunk13357063shrunk
shuck144314533sh_uck
shun75122773sh_u_n
shuns85018143sh_uns
shunt85226503sh_unt
shush113812543sh_ush
shut76137583sh_u_t
shute84520343sh_ute
shuted103913163shuted
shuts85622473sh_uts
shyly144811573sh_yly
sild55030583s__ild
skald104210173s_kald
skoal93811453skoal_
skoaled12226043skoaled
skoals10438233skoals
skulk8479623s_kulk
skull94812033s_kull
sloid64619693slo_id
slojd13378843slo_jd
sloped94216853sloped
slouch11438523slouch
slough10539233slough
slowed104617073slowed
slowly1237153slowly
sloyd9409683slo_yd
slued64220513s_lued
smoked134311723smoked
smolt74824163smo_lt
smoulder1133443smoulder
snood64616163sno_od
snool55118643snool_
snooled84513933snooled
snools65715873snools
snored74819543snored
snout54530633snou_t
snouted84311343snouted
snouts64915863snouts
snouty9419953snouty
snowed104613613snowed
socle7419573s_ocle
sod46053703s_o__d
soil46138823s_oil_
soiled73822473s_oiled
soils55327983s_oils
sol37256623s_o_l_
sola45541863s_o_la
soldi65717193s_o_ldi
soldo67116563s_o_ldo
sole46053673s_o_le
soled65835173s_oled
soli46637003s_o_li
solid65025073s_olid
solo45538943s_o_lo
sols45448163s_o_ls
solum74717603s_olum
solus54726983s_olus
sonly85718053s_only
sooted73922583sooted
sord56237203s_o_rd
sored66141783s_ored
sou37853693s_ou__
sough95320463s_ough
souk86127173s_ou_k
souks94820523s_ouks
sounds74616183s_ounds
soup66232913s_ou_p
souped95017673s_ouped
soups75322943s_oups
soupy106115403s_oupy
sour45935893s_ou_r
soured74921863s_oured
sourly93612203s_ourly
sours55230503s_ours
sous46947213s_ou_s
souse56530773s_ouse
soused74822983s_oused
south85223573s_outh
sowed94933863s_owed
spoil75818643spoil_
spoiled104811353spoiled
spoils84614533spoils
spoilt85016593spoilt
spoked134413893spoked
spool75219043spool_
spooled104613523spooled
spools85115913spools
spored94821793spored
sporule937273sporule
spouse84112513spouse
spoused10349653spoused
spout75029633spou_t
spouted103412263spouted
spouts85115113spouts
spud75818493s_pu_d
spued84918473s_pued
squad155110793s_quad
squid154211903s_quid
stoked114718293stoked
stole54928813sto_le
stoled74521593stoled
stolid74213173stolid
stoned75923143stoned
stood65517713sto_od
stool55619893stool_
stooled84313893stooled
stools65117023stools
stoped94721013stoped
stored75524213stored
stounds8377823stounds
stoup75517073stou_p
stoups85313273stoups
stour54916743stou_r
stoure64814943stoure
stours65015623stours
stoury9529943stoury
stout57434053stou_t
stoutly1035833stoutly
stouts65019003stouts
stowed105817203stowed
stroud7310383strou_d
stud56220093s_tu_d
stull54916273s_tull
sudd64719773s__udd
sued56537933s__ued
sulk85326653s__ulk
sulu45128423s__ulu
surd56433813s__urd
sword95214113swo_rd
swoun84811493swou_n
swounds11405643swounds
swouned11366663swouned
swouns9358243swouns
thole85620843tho_le
tholed105113873tholed
thou76722213thou__
though139410763though
thous86017253thou_s
thud85613913th_u_d
told56132203_to_ld
uphold12126903upho_ld
whole114418093who_le
wholly15366573wholly
whored135512123whored
whorl114612453whorl_
whorled14366903whorled
whorls124410163whorls
woald94813073_woald
wold85429073_wo_ld
world96915363_world
wound94414213_wound
yauld95511183_yauld

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.1231452772.4
2DLD Change Limit1127164596.33017806.6
3Display Results4594590.1403278.6
 (SQL Overall)1786914596.59327103.1
 
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.