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

179 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
sheikhs1723399(None) 
sheikh16206991sheikh_
sheiks132510011sheik_s
sheaths1358752sheaths
sheik122514662sheik__
sheilas1059402sheilas
sheuchs15234932sheuchs
sheughs14264532sheughs
shrikes144412392shrikes
shtiks13297832shtik_s
sleighs11245672sleighs
checks174912703check_s
cheeks154712783cheek_s
chetahs15347073chetahs
cheths14389823che_ths
haiks125120933_haik_s
haikus13538293_haikus
heaths126316383_heaths
hecks145220653_heck_s
hehs106723963_he__hs
heigh124812543_heigh_
height134713433_height
heights14399443_heights
heils85222193_hei_ls
heirs85618563_hei_rs
heishi1235843_heishi
heists96814633_heists
heths116317783_he_ths
heuchs14447923_heuchs
heughs13516903_heughs
highs125412523_h_ighs
hikes125426983_h_ikes
khedahs1852953khedahs
kheths16495973khe_ths
neighs10387733_neighs
samekhs16303923samekhs
schriks16185743schrik_s
schtiks16184743schtik_s
seeings84411293seeings
seeks94724643s_eek_s
seiche11811833s_eiche
seiches12513813s_eiches
seifs85019333s_ei_fs
seines65029903s_eines
seis45542393s_ei__s
seises64026713s_eises
seisms84912143s_eisms
seizes154317533s_eizes
selahs9313213s_elahs
shackos16429023shackos
shacks154817563shack_s
shahs115919513sh__ahs
shairds11216263shairds
shairns10276783shairns
shakes135024593sh_akes
shakos134912193sh_akos
shanks135315583shank_s
shariahs14206393shariahs
sharks135019723shark_s
shaughs14245283shaughs
sheafs124912883she_afs
sheals94420643she_als
shears93820903she_ars
sheas86331793she__as
sheath12412893sheath_
sheathe1348993sheathe
sheathes14610193sheathes
sheaves134412973sheaves
sheds96122703she__ds
sheens95116993she_ens
sheers94322403she_ers
sheesh1237813sheesh_
sheets93918503she_ets
sheeves133911953sheeves
sheikdom1842133sheikdom
sheikdoms1941903sheikdoms
sheikhdom2251073sheikhdom
sheikhdoms2351023sheikhdoms
sheila969843shei_la
sheitan1036573sheitan
sheitans1155603sheitans
shekel1338383she_kel
shekels1436043shekels
shells94319523she_lls
sheltas10279673sheltas
shelves134112093shelves
shends105313773she_nds
sheols94614163she_ols
sheqels1934753sheqels
sherds105614723she_rds
sheriffs17253923sheriffs
sherifs13299683sherifs
sherpas1238093sherpas
sherris10168803sherris
shes75734353she___s
sheuch14267043sheuch_
sheugh13295883sheugh_
shewers134312053shewers
shews115924713she__ws
shibahs15275643shibahs
shields11538043shields
shiels95418923sh_iels
shiers94921753sh_iers
shies86136553sh_i_es
shifts124412943sh_ifts
shikar1336803sh_ikar
shikars1436183sh_ikars
shiksa1394653sh_iksa
shiksas1484643sh_iksas
shikse1386073sh_ikse
shiksehs1892093sh_iksehs
shikses14116573sh_ikses
shills94519613sh_ills
shims104422553sh_i_ms
shines95028913sh_ines
shins85131043sh_i_ns
ships105123773sh_i_ps
shires95225573sh_ires
shirks134814123sh_irks
shirrs94413173sh_irrs
shirts94918343sh_irts
shists96515113sh_ists
shits84731173sh_i_ts
shivahs16375723shivahs
shivas124512413sh_ivas
shives124921413sh_ives
shivs115018803sh_i_vs
shocks154414583shock_s
shooks134515633shook_s
shrieks14377673shrieks
shrifts1335963shrifts
shrike134513243shrik_e
shrills10389933shrills
shrimps14516753shrimps
shrines104618693shrines
shrinks14397913shrinks
shris84221453shri__s
shrives134416173shrives
shticks16356963shticks
shtik123210963shtik__
shucks154010413shuck_s
sighs95416743s__ighs
sikas94617023s__ikas
sikes96236083s__ikes
sinhs86719603s__inhs
skeigh14265903skeigh_
skeins103911903skei_ns
skreighs16203153skreighs
sleeks104512463sleek_s
sleigh10258203sleigh_
sleight11279023sleight
sleights12275913sleights
sleuths1034743sleuths
smeeks12428433smeek_s
smerks12449713smerk_s
smiths114711023s_miths
sneaks104312493sneak_s
snecks124410033sneck_s
speaks125114583speak_s
specks144312703speck_s
speils84116223spei_ls
speirs85013233spei_rs
speises93813933speises
speiss84311643spei_ss
spikes124520713s_pikes
spiks114117473s_pik_s
steaks104415853steak_s
steeks103613703steek_s
steins64818343stei_ns
stichs114511653s_tichs
strikes114719093strikes
theines104013233theines
theins95015423thei_ns
theirs94610353thei_rs
theisms1237763theisms
theists1039153theists
thighs1346633th_ighs
weighs13338873_weighs
whelks16367323whelk_s

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271796.72019944.5
3Display Results1791790.0602983.3
 (SQL Overall)1786911797.17024922.0
 
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.