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

153 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
shibahs1527564(None) 
shibah14387471shibah_
shivahs16375721shivahs
shahs115919512sh__ahs
shikars1436182shikars
shittahs14114102shittahs
shivah15488542shivah_
shivas124512412shiva_s
subahs114512382s_ubahs
whidahs1743332whidahs
aliyahs13395323aliyahs
bimahs13508303_bimahs
casbahs1436463casbahs
ceibas1038503ceiba_s
chalahs15289883chalahs
chetahs15347073chetahs
chias104625523chi_a_s
chiaus113611313chi_aus
chicas135916473chica_s
chimars144010593chimars
chinas115119403china_s
ghiblis1353343ghiblis
hahs108333363_h__ahs
hibachi1744203_hibachi
hibachis1863953_hibachis
highs125412523_hi_ghs
hijabs1833083_hijabs
hijrahs2043443_hijrahs
horahs126313873_horahs
jubbahs2143623jubbahs
kasbahs1634363kasbahs
khedahs1852953khedahs
khirkahs1741423khirkahs
kiblahs1634153_kiblahs
ohias84415573ohi_a_s
phials1158873phi_als
pibals103813083_pibals
sabals84618863s_abals
sabbaths1543973sabbaths
sabbats1138633sabbats
sahibs1137083sahib__s
sahiwals1443643sahiwals
saigas74114293saiga_s
sambals115213483sambals
sambars115113843sambars
sambas104219263samba_s
scubas103710223scuba_s
seabags1037483seabags
seitans73312303seitans
selahs9313213s_elahs
shads95124483sh__ads
shags95123863sh__ags
shah105627783sh__ah_
shaitans1136413shaitans
shamans123610903shamans
shamas113717943shama_s
shams105829413sh__ams
shariahs14206393shariahs
shaughs14245283shaughs
shaws116226263sh__aws
shays116021433sh__ays
sheafs124912883sh_eafs
sheals94420643sh_eals
shears93820903sh_ears
sheas86331793sh_ea_s
sheaths1358753sheaths
shebang1334843shebang
shebangs1443593shebangs
shebeans1344703shebeans
sheikhs17233993sheikhs
sheilas1059403sheila_s
sheitans1155603sheitans
sheuchs15234933sheuchs
sheughs14264533sheughs
shiatsu1033433shi_atsu
shields11538043shields
shiels95418923shi_els
shiers94921753shi_ers
shies86136553shi__es
shifts124412943shi_fts
shikar1336803shika_r
shikari1444513shikari
shikaris1544923shikaris
shiksas1484643shiksas
shiksehs1892093shiksehs
shikses14116573shikses
shills94519613shi_lls
shims104422553shi__ms
shindys14314133shindys
shiners104015943shiners
shines95028913shi_nes
shins85131043shi__ns
shiplaps1544363shiplaps
ships105123773shi__ps
shipways1944073shipways
shires95225573shi_res
shirks134814123shi_rks
shirrs94413173shi_rrs
shirts94918343shi_rts
shists96515113shi_sts
shitake1455623shitake
shitakes1546113shitakes
shits84731173shi__ts
shittah1385153shittah_
shiva115915003shiva__
shivers133714833shivers
shives124921413shi_ves
shivs115018803shi__vs
shmears1277073shmears
shnaps1148083sh_naps
shoals94215793sh_oals
shoats94117083sh_oats
shofars1335833shofars
shorans102812413shorans
shwas116415103sh_wa_s
sials54227243s_i_als
sibbs96211903s_ib_bs
sibs65933543s_ib__s
sibyls1135303s_ibyls
sighs95416743s_i_ghs
sikas94617023s_ika_s
simars84916933s_imars
simas75727553s_ima_s
sinhs86719603s_i_nhs
sirrahs10377303sirrahs
sisals63013573s_isals
sitars65417593s_itars
sixths16416373s_ixths
sizars154812623s_izars
skibobs1542993skibobs
smiths114711023smi_ths
snibs75613763snib__s
sobas74424253s_oba_s
spicas104715823spica_s
spilths12356023spilths
spinals93911863spinals
spirals93212513spirals
spitals93011593spitals
stichs114511653sti_chs
subah106015213s_ubah_
subas74724073s_uba_s
subbass1138033subbass
succahs1435323succahs
sukkahs1382703sukkahs
sunbaths1344383sunbaths
sunnahs10326593sunnahs
surahs94515543s_urahs
thighs1346633thi_ghs
thirams1236823thirams
tribals9610753tribals
whidah1634803whidah_
whydahs2041883whydahs
yeshivahs215863yeshivahs

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271535.79623124.1
3Display Results1531530.0463326.1
 (SQL Overall)1786911535.99829791.8
 
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.