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

276 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
sheikh1620699(None) 
sheik122514661sheik_
sheikhs17233991sheikhs
sheiks132510011sheiks
heigh124812542_heigh
sheath12412892sheath
sheesh1237812sheesh
sheila969842sheila
sheuch14267042sheuch
sheugh13295882sheugh
shrike134513242shrike
shtik123210962shtik_
shtiks13297832shtiks
skeigh14265902skeigh
sleigh10258202sleigh
aweigh1334933aweigh
check164714713check_
checks174912703checks
cheek145115713cheek_
cheeks154712783cheeks
cheeky18448613cheeky
cherish15310463cherish
chetah14399583chetah
cheth135013823che_th
dreich12377723dreich
dreigh11246443dreigh
haik115526983_haik_
haika125313793_haika
haiks125120933_haiks
haiku126113693_haiku
heath115724283_heath
heck135826493_heck_
hecks145220653_hecks
heh96039623_he__h
height134713433_height
heil76328933_hei_l
heils85222193_heils
heir77523803_hei_r
heirs85618563_heirs
heishi1235843_heishi
heist87030913_heist
heth107028023_he_th
heuch135312333_heuch
heugh125410923_heugh
high116619923_h_igh
hike116830393_h_ike
khedah1743643khedah
kheth15509753khe_th
neigh94912383_neigh
saith85826553s_aith
samekh15355133samekh
schrik15206703schrik_
schriks16185743schriks
schtik15185423schtik_
schtiks16184743schtiks
seeing74222143seeing
seek85935483s_eek_
seeks94724643s_eeks
sei36048933s_ei__
seiche11811833s_eiche
seif75638733s_ei_f
seifs85019333s_eifs
seine55732873s_eine
seis45542393s_ei_s
seise54727853s_eise
seism75019023s_eism
seize143819503s_eize
selah8319613s_elah
shack145321753shack_
shacko153810113shacko
shacks154817563shacks
shah105627783sh__ah
shaird10288703shaird
shairn9269063shairn
shake124726403sh_ake
shako125516093sh_ako
shaky154616843sh_aky
shank125422193shank_
shanks135315583shanks
shariah132210533shariah
shark126225023shark_
sharks135019723sharks
shaugh13287433shaugh
she66837693she___
shea76031573she__a
sheaf115424123she_af
sheafs124912883sheafs
sheal84927703she_al
sheals94420643sheals
shear85424833she_ar
shears93820903shears
sheas86331793she_as
sheathe1348993sheathe
sheaths1358753sheaths
sheave124514003sheave
shed86536153she__d
shedlike1635833shedlike
sheds96122703she_ds
sheen85023313she_en
sheens95116993sheens
sheeny124912193sheeny
sheep105321523she_ep
sheepish1645413sheepish
sheer84726893she_er
sheers94322403sheers
sheet84836963she_et
sheets93918503sheets
sheeve123412843sheeve
sheikdom1842133sheikdom
sheikhdom2251073sheikhdom
sheilas1059403sheilas
sheitan1036573sheitan
shekel1338383shekel
shelf115221113she_lf
shell84424123she_ll
shells94319523shells
shelly124414473shelly
shelta93111793shelta
shelty124011553shelty
shelve124012763shelve
shelvy15377863shelvy
shend94719973she_nd
shends105313773shends
shent85933503she_nt
sheol84318373she_ol
sheols94614163sheols
sheqel1846523sheqel
sherd96321153she_rd
sherds105614723sherds
sherif122915243sherif
sheriff16287693sheriff
sherifs13299683sherifs
sherpa1138093sherpa
sherry124510413sherry
shes75734353she__s
sheuchs15234933sheuchs
sheughs14264533sheughs
shew108030763she__w
shewed134716183shewed
shewer124515113shewer
shewing143812193shewing
shewn115715703she_wn
shews115924713she_ws
shh97121073sh___h
shibah14387473shibah
shied96125493sh_ied
shiel811023773sh_iel
shield106212973shield
shiels95418923shiels
shier85428943sh_ier
shiers94921753shiers
shies86136553sh_ies
shiest95821533shiest
shift114225143sh_ift
shikar1336803sh_ikar
shiksa1394653sh_iksa
shikse1386073sh_ikse
shikseh17102603sh_ikseh
shill85325333sh_ill
shily115222013sh_ily
shim95827863sh_i_m
shims104422553sh_ims
shin75634313sh_i_n
shine85533093sh_ine
shins85131043sh_ins
shiny115122143sh_iny
ship95228243sh_i_p
ships105123773sh_ips
shire84727133sh_ire
shirk124817843sh_irk
shirks134814123shirks
shirr84716923sh_irr
shirt84533903sh_irt
shist84829613sh_ist
shit76745943sh_i_t
shits84731173sh_its
shiv105721173sh_i_v
shiva115915003sh_iva
shivah15488543shivah
shive114423423sh_ive
shivs115018803sh_ivs
shock144917033shock_
shocks154414583shocks
shoeing113211883shoeing
shook124920163shook_
shooks134515633shooks
shrewish1744743shrewish
shri76021703shri__
shriek134211103shriek
shrieks14377673shrieks
shrieky17364803shrieky
shrift12413543shrift
shrikes144412393shrikes
shrill94712303shrill
shrimp13478773shrimp
shrine94920053shrine
shrink134511733shrink
shrinks14397913shrinks
shris84221453shri_s
shrive125216953shrive
shtick15308023shtick
shticks16356963shticks
shticky19344473shticky
shuck144314533shuck_
shucks154010413shucks
shush113812543sh_ush
shying134211843shying
sidh86222993s__idh
sigh85625893s__igh
sika86021323s__ika
sike87138783s__ike
sinh76238043s__inh
sith75435153s__ith
skein94814413skei_n
skeins103911903skeins
sketch1535363sketch
skreigh15243703skreigh
sleek94619043sleek_
sleeks104512463sleeks
sleeky13398963sleeky
sleighs11245673sleighs
sleight11279023sleight
sleuth937233sleuth
smeek114912353smeek_
smeeks12428433smeeks
smerk115412723smerk_
smerks12449713smerks
smith107818053s_mith
sneak96016173sneak_
sneaks104312493sneaks
sneaky13427843sneaky
sneck114713663sneck_
snecks124410033snecks
sneesh945893sneesh
speak114618673speak_
speaks125114583speaks
speck135115653speck_
specks144312703specks
speech1347563speech
speil75618643spei_l
speils84116223speils
speir75315363spei_r
speirs85013233speirs
speise84614253speise
speiss84311643speiss
spik105419713s_pik_
spike114922843s_pike
spiks114117473s_piks
spiky146014113s_piky
squish1838573squish
steak95219803steak_
steaks104415853steaks
steek95418003steek_
steeks103613703steeks
stein54620543stei_n
steins64818343steins
stench114111163stench
stich104117923s_tich
strike105619733strike
swish115114823s_wish
swith115917403s_with
thein85919023thei_n
theine94814923theine
theins95015423theins
their85512153thei_r
theirs94610353theirs
theism1139483theism
theist9314763theist
thigh12410123th_igh
weigh125412513_weigh
whelk154311063whelk_
whelks16367323whelks
whelky19314973whelky
wheyish1944063wheyish
which163910083wh_ich
whish144512923wh_ish

Search took 6 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.373479064.3
2DLD Change Limit1127162765.45320670.5
3Display Results2762760.0932967.7
 (SQL Overall)1786912765.91930189.4
 
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.