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

230 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
henbit11141200(None) 
henbits12177001henbits
debit85727852de_bit
habit103027022h_abit
hent76656382hen__t
hermit11519442hermit
hobbit132810542hobbit
sennit63117922sennit
ambit94223713_ambit
bandit93821133bandit
bankit123617043bankit
bedsit9312843bedsit
befit105222663be_fit
benefit1248073benefit
bennet84823363bennet
benni74715363benni_
bennis84314803bennis
bent67759913ben__t
benzin1738933benzin
binit76431583bin_it
bit57070903___bit
cebid104314073ce_bid
cenobite1246853cenobite
cent67451013cen__t
confit113316403confit
cubit94122893_cubit
debits94214503de_bits
debt77139023de_b_t
debut86024143de_but
deceit93018213deceit
demit84832303de_mit
deni56929393den_i_
denim85518843den_im
density1137583density
dent57158413den__t
dentil74017883dentil
dentin73919573dentin
dentist8316743dentist
deorbit1048173deorbit
ebbet93517293_ebbet
edit54934863_e_dit
emit65438423_e_mit
enact73525363_enact
endite73817593_endite
engirt71112613_engirt
enlist6417043_enlist
enmity1137483_enmity
entia5318203_entia
entity9312053_entity
exit114428673_e_xit
gambit114714213gambit
genet66038683gen_et
genic85119393gen_ic
genie66124923gen_ie
genii64514173gen_ii
genip84415203gen_ip
gent56954393gen__t
gentil74115123gentil
gerbil938343gerbil
habits113014653h_abits
haffit1538533haffit
hagbut1278923hagbut
hankie133915713hankie
hant75461593han__t
heart85440743he_art
heat77061423he__at
hebe96424703he_b_e
hebes105521673he_bes
hectic132311523hectic
heft106736293he__ft
height134713433height
heil76328933he__il
heinie92512663heinie
heir77523803he__ir
heist87030913he_ist
helio85321193he_lio
helix154413013he_lix
helmet113718933helmet
helot85332683he_lot
hemic125718623he_mic
hemin103620933he_min
hemoid12313513hemoid
hempie132410563hempie
hen67555273hen___
henbane1237353henbane
hence104920043hen_ce
henge94819833hen_ge
henges104516463henges
henley1237483henley
henlike1448693henlike
henna84414043hen_na
hennas94211803hennas
hennish1336863hennish
henries102718283henries
henry114014473hen_ry
henrys12366103henrys
hens75642573hen__s
hented104218753hented
henting113719653henting
hents87330743hen_ts
hepcat13611823hepcat
herb94730963herb__
herbal112513493herbal
herbed123513453herbed
herbier1239593herbier
herbiest1339993herbiest
herbs105520503herb_s
herby134715313herb_y
herdic123112303herdic
hereat93527413hereat
herein93717793herein
heriot9422343heriot
hermits12312143hermits
hernia9312293hernia
heroic113516923heroic
heroin94420593heroin
hessite1038993hessite
hest75950773he__st
het67674313he___t
hint77455743hin__t
hit66569193h___it
hobbits14317553hobbits
honest94822423honest
hongi96715873hongi_
honkie133011673honkie
howbeit1545663howbeit
hunkie133812383hunkie
hunt76445493hun__t
hyenic1438723hyen_ic
hyenoid1448613hyenoid
jennet134714953jennet
jesuit1339583jesuit
kebbie1435813kebbie
kent86846963ken__t
knit85728143_kn_it
legit61323503le_git
lenis56326863len_is
lenite6719983len_ite
lenity9612713len_ity
lent46360533len__t
lentic83515743lentic
lentil64315393lentil
megabit12117963megabit
menhir1136783menhir
merit7339183me_rit
newbie11135413newbie
nit37065943__n_it
obit66837083__obit
orbit73622063_orbit
pandit93820753pandit
peewit111110903peewit
pencil103712973pencil
penis75129323pen_is
penlite9313243penlite
penni74617903penni_
pennia84412973pennia
pennis84315743pennis
pensil83013333pensil
pent66559073pen__t
penult8314653penult
permit10321683permit
petit74332653pe_tit
pewit104622793pe_wit
phenix1837133phen_ix
probit103218353probit
pundit92914183pundit
qubit164218993_qubit
rabbit102914563rabbit
rebait8320403rebait
rebid85121363re_bid
rebut75927383re_but
recit75235103re_cit
redbait1039803redbait
reedit7617223reedit
reemit8717223reemit
refit84230063re_fit
reknit10312533reknit
relit55340683re_lit
remit75737223re_mit
renail65020763renail
renest64529713renest
renig64518913ren_ig
renin54830033ren_in
rennet64624853rennet
rennin63914033rennin
rent46661243ren__t
resit54241043re_sit
sengi64016513sengi_
seniti64317223sen_iti
sennet64224143sennet
sennits73811283sennits
sent46963013sen__t
senti56226703senti_
shent85933503shen__t
sherbet12311383sherbet
snit46342473_sn_it
sunlit61516103sunlit
tenail64516113tenail
tenant6322473tenant
tenet55542213ten_et
tenia55324483ten_ia
tennis64015303tennis
tennist72813113tennist
tenpin8310583tenpin
tensity1039103tensity
tent46159863ten__t
tentie62521183tentie
tenuis64213083tenuis
tenuity1037453tenuity
tenuti638973tenuti
terbia8311153terbia
terbic10410963terbic
territ63421373territ
thermit12312013thermit
tidbit938493tidbit
titbit839823titbit
turbit8715113turbit
unbid83214643_unbid
unfit84518563_unfit
unit45140073_un_it
unlit55025463_unlit
unwit84417523_unwit
venin85118663ven_in
vent76049053ven__t
verbid122311313verbid
went76051873wen__t
weskit1338343weskit
xenia124814773xen_ia
xenic144114643xen_ic
zenith1839073zen_ith

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.390458182.1
2DLD Change Limit1127162304.83023336.6
3Display Results2302300.0763026.3
 (SQL Overall)1786912305.29633740.7
 
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.