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

155 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
heishi123584(None) 
geisha1035212geisha
heigh124812542heigh_
height134713432height
heirship1645052heirship
heist87030912heis_t
heists96814632heists
rishi8311252_rishi
apish105116633apish_
ceili75814793cei_li
cesti75217423ce_sti
cherish15310463cherish_
chichi1637093chichi
cuish10313173cuish_
dashi95013113_dashi
deash95617243deash_
deism84116033deis_m
deisms94411043deisms
deist64633593deis_t
deistic10311173deistic
deists74916433deists
delish105215613delish_
disci85815023_disci
dish86328333_dish_
dishy125712353_dishy
eight94928053_eight
elhi7612403_e_lhi
feist86230073feis_t
feists94915313feists
feisty12449293feisty
fetish12310373fetish_
fish106926273_fish_
fishy146011663_fishy
fleishig1542893fleishig
geishas1135083geishas
harsh116418053harsh_
hash106936503h_ash_
headship1745743headship
heath115724283heath_
heaths126316383heaths
heathy156111213heathy
hegari1039523hegari
heh96039623he__h_
hehs106723963he__hs
heifer1238203heifer
heighth13366343heighth
heights14399443heights
heil76328933hei__l
heiled104415613heiled
heils85222193hei_ls
heimish1535463heimish_
heinie92512663heinie
heir77523803hei__r
heired103813043heired
heirs85618563hei_rs
heirships1744963heirships
heisted113210653heisted
heister103613623heister
heisting123411043heisting
hellish13310723hellish_
hems95534943hems__
hennish1336863hennish_
hens75642573hens__
hermai118912863hermai
hers75844873hers__
hes66654203he_s__
hest75950773he_s_t
hests85829933he_sts
heth107028023he_th_
heths116317783he_ths
hets75547203hets__
heuch135312333heuch_
heuchs14447923heuchs
heugh125410923heugh_
heughs13516903heughs
hews105631573hews__
hies74842833hies__
high116619923h_igh_
highs125412523h_ighs
hight125327233h_ight
hili75626633h_i_li
his66359503h_is__
hisn79620933h_is_n
hispid1238173h_ispid
hiss75629213h_is_s
hissy116112123h_issy
hist76551543h_is_t
hists86328373h_ists
hoise85224773hois_e
hoised105117433hoised
hoises94823673hoises
hoist86433213hois_t
hoists95516023hoists
hush105224113h_ush_
knish1238603knish_
leash85519213leash_
leis45739603leis__
lichi104412953_lichi
menisci1144783menisci
mensh105413563mensh_
mesh96823003me_sh_
meshy135612783me_shy
mishit112618203_mishit
neigh94912383neigh_
neighs10387733neighs
neist54628443neis_t
newish1237903newish_
nisei54214353_nisei
nisi45823243_nis_i
orisha936773orisha
peise75825773peis_e
peised94817683peised
peises84125043peises
perish114619063perish_
petsai838083petsai
pish96127913_pish_
poisha1135723poisha
reis45343233reis__
relish93916953relish_
resh76523453re_sh_
reship11310673re_ship
rishis9312453_rishis
roshi8310753_roshi
seiche11811833seiche
seis45542393seis__
seise54727853seis_e
seised74218123seised
seiser65318343seiser
seises64026713seises
seisin63715123seisin
seism75019023seis_m
seismic1145753seismic
seisms84912143seisms
seisor63712343seisor
sensei64712593sensei
sheesh1237813sheesh_
sheikh16206993sheikh_
sheikhs17233993sheikhs
sushi8310493_sushi
swish115114823swish_
swishy15365843swishy
theism1139483theis_m
theisms1237763theisms
theist9314763theis_t
theistic1348153theistic
theists1039153theists
weigh125412513weigh_
weighs13338873weighs
weight133914183weight
welsh113110363welsh_
wheyish1944063wheyish_
whish144512923whish_
whisht154510813whisht
wish107228733_wish_
wisha114910853_wisha

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.393454684.5
2DLD Change Limit1127161554.92022909.8
3Display Results1551550.0463369.6
 (SQL Overall)1786911555.35933344.1
 
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.