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
shtetl93643(None) 
shtetel1033931shtetel
shtetls1034571shtetls
sheal84927702sh_eal
sheet84836952sheet_
sheets93918492sheets
shell84424122sh_ell
sheol84318362sh_eol
shiel811023772shie_l
shtetels1143222shtetels
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
hotel85520743hote_l
hyetal1236543_hyetal
khet116328623kh_et_
kheth15509753kh_eth
khets124913433kh_ets
kittel10368863kittel
luteal64411483luteal
motel76623243mote_l
motet75641193motet_
motets84216193motets
octet7324063octet_
octets839403octets
osteal6312953osteal
ratel54224883rate_l
retell63813643retell
safety12206913safety
sate45556103sate__
sated66238533sate_d
sateen63815013sateen
satem76021453sate_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
shaft115725253shaft_
shafts125411433shafts
shall85024053sh_all
shalt85534483shalt_
shanti94014073shanti
shanty124715113shanty
shat76456593sh_at_
shatter103615693shatter
shaul85418103sh_aul
shawl116217573sh_awl
she66837693sh_e__
shea76031573sh_e_a
sheaf115424123sh_eaf
sheals94420643sh_eals
shear85424833sh_ear
sheas86331793sh_eas
sheath12412883sheath
shed86536153sh_e_d
sheds96122703sh_eds
sheen85023313sh_een
sheens95116993sheens
sheeny124912193sheeny
sheep105321523sh_eep
sheer84726893sh_eer
sheerly13337703sheerly
sheers94322403sheers
sheesh1237813sheesh
sheeted113813033sheeted
sheeter103814903sheeter
sheeve123412843sheeve
shegetz2044263shegetz
sheik122514653sh_eik
sheila969843sh_eila
shekel1338383shekel
shelf115221113sh_elf
shells94319523sh_ells
shelly124414463sh_elly
shelta93111783shelta
shelty124011543shelty
shend94719973sh_end
shent85933493sh_ent
sheols94614153sh_eols
sheqel1846523sheqel
sherd96321153sh_erd
shes75734353sh_e_s
shew108030763sh_e_w
shewn115715703sh_ewn
shews115924713sh_ews
shied96125493shie_d
shield106212973shield
shiels95418923shiels
shier85428943shie_r
shiers94921753shiers
shies86136553shie_s
shiest95821523shiest
shift114225133shift_
shifts124412933shifts
shifty15409253shifty
shill85325333sh_ill
shirt84533893shirt_
shirts94918333shirts
shirty124312553shirty
shist84829603shist_
shists96515103shists
shit76745933sh_it_
shits84731163sh_its
shitted114212043shitted
shitty124110053shitty
shlep104914833shle_p
shlepp13366193shlepp
shleps114710333shleps
shmear1176933shmear
shoal83920263sh_oal
shoat85633943shoat_
shoats94117073shoats
shoe75933433shoe__
shoed95723003shoe_d
shoer84722153shoe_r
shoers94518323shoers
shoes85429653shoe_s
shool84523143sh_ool
shoot84235893shoot_
shoots94619343shoots
shorl84720243sh_orl
short85040523short_
shortly13387563shortly
shorts95321733shorts
shorty124313193shorty
shot76150243sh_ot_
shote85526083sh_ote
shotes95321893shote_s
shots84730833sh_ots
shott85332173sh_ott
shotted113912383shotted
shotten10288443shotten
shotts93614683shotts
shout85433163shout_
shouts94017713shouts
shovel124611313shovel
shred98125613shre_d
shreds105613053shreds
shrew119720163shre_w
shrewd136810773shrewd
shrews129313913shrews
shrill94712303shrill
shtetlach1751483shtetlach
shtick15308013shtick
shtik123210943sht_ik
shtiks13297823shtiks
shul75823153sh__ul
shunt85226503shunt_
shunts95712013shunts
shut76137583sh_ut_
shute84520343sh_ute
shuted103913163shute_d
shutes93518213shute_s
shuteye1343353shuteye
shuts85622473sh_uts
shutter103712133shutter
shuttle1046093shuttle
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
sotol54917643sot_ol
sotted74121393sotted
speel74420763s_peel
speil75618643s_peil
spell75020303s_pell
spelt75430193s_pelt
spiel74623913spie_l
squeal1538013squeal
stall54722353s_tall
stat47352693s_tat_
statal61613223s_tatal
state56237333s_tate
stats55933363s_tats
stead65520273s_tead
steak95219803s_teak
steals64020063s_teals
steam76322923s_team
steed66024943s_teed
steek95418003s_teek
steels64117983s_teels
steely93612573s_teely
steep76020703s_teep
steer55423863s_teer
stein54620533s_tein
stela54019043s_tela
stele55026843s_tele
stella63612973s_tella
stem610628243s_te_m
stems75219953s_tems
steno54716863s_teno
stent55634513s_tent
stents65019453s_tents
step67126293s_te_p
steps76619883s_teps
stere55328543s_tere
stern55319123s_tern
sterol6613323s_terol
stew77525463s_te_w
stews85519143s_tews
stewy116112063s_tewy
stey76224413s_te_y
still54922073s_till
stilt54831983s_tilt
stool55619893s_tool
stot46347323s_tot_
stots54828543s_tots
stott56929783s_tott
streel64214023streel
stull54916273s_tull
suet46754823s_uet_
suets55126103s_uets
suety85318493s_uety
surety93515003surety
sutta54015333sut_ta
suttee63721543suttee
sweet85330523sweet_
sweetly1335593sweetly
sweets94214433sweets
swell84815983s_well
teal45546503__teal
teel46335803__teel
tel35647903__te_l
tell44934703__tell
tet39274983__tet_
teth76327883__teth
tets45847453__tets
theta83414573th_eta
wheal115716183wh_eal
wheel115515333wh_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.236757165.3
2DLD Change Limit1127162866.03018692.5
3Display Results2862860.0933075.3
 (SQL Overall)1786912866.35928100.5
 
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.