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

286 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
shtetl93644(None) 
shtetel1033941shtetel
shtetls1034581shtetls
sheal84927702sh_eal
sheet84836962sheet_
sheets93918502sheets
shell84424122sh_ell
sheol84318372sh_eol
shiel811023772shie_l
shtetels1143232shtetels
steal56125472s_teal
steel55721992s_teel
stet45947322s_tet_
stets55423912s_tets
artel56122743arte_l
betel74419903bete_l
botel75121863bote_l
chaeta11310683chaeta
chaetal1238283chaetal
chattel12388893chattel
cheth135013823ch_eth
chiel104918973chie_l
dottel73610893dottel
esthete1047433esthete
ghetto1036073ghetto
haet75659503_haet_
haets86525123_haets
heal75645693_h_eal
heel75034223_h_eel
heil76328933_h_eil
hell75637893_h_ell
herl75834553_h_erl
het67674313_h_et_
heth107028023_h_eth
hets75547203_h_ets
hotel85520753hote_l
hyetal1236543_hyetal
khet116328623kh_et_
kheth15509753kh_eth
khets124913433kh_ets
kittel10368873kittel
luteal64411483luteal
motel76623243mote_l
motet75641193motet_
motets84216193motets
octet7324063octet_
octets839403octets
osteal6312963osteal
ratel54224883rate_l
retell63813643retell
safety12206913safety
sate45556103sate__
sated66238533sate_d
sateen63815013sateen
satem76021463sate_m
sates54949323sate_s
satiety1038203satiety
seal45654373s__eal
seel45042983s__eel
segetal868383segetal
sel38253323s__e_l
sell45840613s__ell
septet8921133septet_
septets998953septets
sestet6826203sestet_
sestets7911473sestets
set36681253s__et_
seta45637313s__eta
setal56430903set_al
sets45549503s__ets
sett45949053s__ett
settee63721023settee
setter64023723setter
settle63915663set_tle
setts55124323set_ts
sextet13916873sextet_
sextets1497143sextets
shaft115725273shaft_
shafts125411443shafts
shall85024053sh_all
shalt85534493shalt_
shanti94014093shanti
shanty124715123shanty
shat76456603sh_at_
shatter103615703shatter
shaul85418103sh_aul
shawl116217573sh_awl
she66837693sh_e__
shea76031573sh_e_a
sheaf115424123sh_eaf
sheals94420643sh_eals
shear85424833sh_ear
sheas86331793sh_eas
sheath12412893sheath
shed86536153sh_e_d
sheds96122703sh_eds
sheen85023313sh_een
sheens95116993sheens
sheeny124912193sheeny
sheep105321523sh_eep
sheer84726893sh_eer
sheerly13337703sheerly
sheers94322403sheers
sheesh1237813sheesh
sheeted113813043sheeted
sheeter103814913sheeter
sheeve123412843sheeve
shegetz2044273shegetz
sheik122514663sh_eik
sheila969843sh_eila
shekel1338383shekel
shelf115221113sh_elf
shells94319523sh_ells
shelly124414473sh_elly
shelta93111793shelta
shelty124011553shelty
shend94719973sh_end
shent85933503sh_ent
sheols94614163sh_eols
sheqel1846523sheqel
sherd96321153sh_erd
shes75734353sh_e_s
shew108030763sh_e_w
shewn115715703sh_ewn
shews115924713sh_ews
shied96125493shie_d
shield106212973shield
shiels95418923shiels
shier85428943shie_r
shiers94921753shiers
shies86136553shie_s
shiest95821533shiest
shift114225143shift_
shifts124412943shifts
shifty15409263shifty
shill85325333sh_ill
shirt84533903shirt_
shirts94918343shirts
shirty124312563shirty
shist84829613shist_
shists96515113shists
shit76745943sh_it_
shits84731173sh_its
shitted114212053shitted
shitty124110063shitty
shlep104914833shle_p
shlepp13366193shlepp
shleps114710333shleps
shmear1176933shmear
shoal83920273sh_oal
shoat85633953shoat_
shoats94117083shoats
shoe75933443shoe__
shoed95723013shoe_d
shoer84722163shoe_r
shoers94518333shoers
shoes85429663shoe_s
shool84523153sh_ool
shoot84235913shoot_
shoots94619363shoots
shorl84720253sh_orl
short85040533short_
shortly13387573shortly
shorts95321743shorts
shorty124313203shorty
shot76150263sh_ot_
shote85526103sh_ote
shotes95321913shote_s
shots84730853sh_ots
shott85332193sh_ott
shotted113912403shotted
shotten10288463shotten
shotts93614703shotts
shout85433173shout_
shouts94017723shouts
shovel124611323shovel
shred98125613shre_d
shreds105613053shreds
shrew119720173shre_w
shrewd136810783shrewd
shrews129313923shrews
shrill94712303shrill
shtetlach1751483shtetlach
shtick15308023shtick
shtik123210963sht_ik
shtiks13297833shtiks
shul75823153sh__ul
shunt85226513shunt_
shunts95712023shunts
shut76137593sh_ut_
shute84520353sh_ute
shuted103913173shute_d
shutes93518223shute_s
shuteye1343363shuteye
shuts85622483sh_uts
shutter103712143shutter
shuttle1046103shuttle
shyer114714783shye_r
shyers124712203shyers
shyest125511833shyest
site47052413site__
sited65130743site_d
sites56045433site_s
sitten64113823sitten
sitter63323383sitter
skeet95429183skeet_
skeets104513253skeets
skell94915833s_kell
sleet55639133sleet_
sleets64318873sleets
sleety94112653sleety
smell74916233s_mell
smelt74726783s_melt
snell54517303s_nell
sorel56231443sore_l
sotol54917653sot_ol
sotted74121403sotted
speel74420763s_peel
speil75618643s_peil
spell75020303s_pell
spelt75430193s_pelt
spiel74623913spie_l
squeal1538023squeal
stall54722353s_tall
stat47352693s_tat_
statal61613223s_tatal
state56237333s_tate
stats55933363s_tats
stead65520273s_tead
steak95219803s_teak
steals64020063s_teals
steam76322933s_team
steed66024943s_teed
steek95418003s_teek
steels64117983s_teels
steely93612573s_teely
steep76020703s_teep
steer55423863s_teer
stein54620543s_tein
stela54019043s_tela
stele55026843s_tele
stella63612973s_tella
stem610628253s_te_m
stems75219953s_tems
steno54716863s_teno
stent55634513s_tent
stents65019453s_tents
step67126293s_te_p
steps76619883s_teps
stere55328543s_tere
stern55319123s_tern
sterol6613333s_terol
stew77525463s_te_w
stews85519143s_tews
stewy116112063s_tewy
stey76224413s_te_y
still54922083s_till
stilt54831983s_tilt
stool55619893s_tool
stot46347333s_tot_
stots54828553s_tots
stott56929793s_tott
streel64214023streel
stull54916273s_tull
suet46754823s_uet_
suets55126103s_uets
suety85318493s_uety
surety93515013surety
sutta54015333sut_ta
suttee63721543suttee
sweet85330523sweet_
sweetly1335593sweetly
sweets94214433sweets
swell84815983s_well
teal45546503__teal
teel46335803__teel
tel35647903__te_l
tell44934703__tell
tet39274993__tet_
teth76327893__teth
tets45847463__tets
theta83414573th_eta
wheal115716183wh_eal
wheel115515343wh_eel
whet105133783wh_et_
whets115019613wh_ets

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.453394461.4
2DLD Change Limit1127162865.87619182.4
3Display Results2862860.0763763.2
 (SQL Overall)1786912866.40527898.7
 
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.