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

206 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
henbits1217700(None) 
henbit111412001henbit_
debits94214502de_bits
habits113014652h_abits
henries102718282henries
hents87330742hen__ts
hermits12312142hermits
hobbits14317552hobbits
sennits73811282sennits
ambits103713413_ambits
bandits103814793bandits
bankits133410153bankits
bedsits1037563bedsits
befits114711503be_fits
benefits1345713benefits
bennets94712163bennets
bennies93917313bennies
bennis84314803benni_s
bents76033693ben__ts
benzins1838693benzins
binits85716673bin_its
bits66148163___bits
cebids11439173ce_bids
cenobite1246853cenobite
cenobites1346203cenobites
cents74730333cen__ts
confits122811423confits
cubits103714033_cubits
debit85727853de_bit_
debts86418373de_b_ts
debuts93911753de_buts
deceits102810883deceits
demits94918073de_mits
denies74729643den_ies
denims95214323den_ims
density1137583density
dentils84115583dentils
dentins83419223dentins
dentist8316743dentist
dentists939263dentists
dents65031803den__ts
deorbits1144613deorbits
derbies103016053derbies
ebbets10376833_ebbets
edits65819033_e_dits
emits75421473_e_mits
enacts84012973_enacts
endite73817593_endite
endites83717063_endites
enlist6417043_enlist
enlists749393_enlists
enmity1137483_enmity
entity9312053_entity
envies9314053_envies
exits125515913_e_xits
gambits12399723gambits
genets75716663gen_ets
genies75324943gen_ies
genips9469943gen_ips
genius74512923gen_ius
gents65729613gen__ts
gerbils1037303gerbils
habit103027023h_abit_
habitus12338173h_abitus
haffits1636193haffits
hagbuts1354933hagbuts
hankies143617763hankies
hants86335403han__ts
hearts96218943he_arts
heats85838403he__ats
heavies132713873heavies
hebes105521673he_b_es
hefts116218153he__fts
heights14399443heights
heils85222193he__ils
heinies102514543heinies
heirs85618563he__irs
heist87030913he__ist
heists96814633he_ists
helios94816633he_lios
helmets12309073helmets
helots95217703he_lots
hemins113417563he_mins
henbane1237353henbane
henbanes1336573henbanes
henges104516463hen_ges
henleys1334843henleys
henlike1448693henlike
hennas94211803hen_nas
hennish1336863hennish
henrys12366103hen_rys
hens75642573hen___s
hent76656383hen__t_
henting113719653henting
hepcats1436473hepcats
herbals122710603herbals
herbier1239593herbier
herbiest1339993herbiest
herbs105520503herb__s
herdics13249523herdics
heriots10312063heriots
hermit11519443hermit_
hernias10310773hernias
heroics122912003heroics
heroins103518013heroins
herries104025073herries
hessite1038993hessite
hessites1138613hessites
hests85829933he__sts
hets75547203he___ts
hinnies103615103hinnies
hints87330623hin__ts
hits75545133h___its
hobbies143813343hobbies
hobbit132810543hobbit_
hongies112716473hongies
honkies143015143honkies
hubbies143211563hubbies
hunkies143214503hunkies
hunts86826173hun__ts
jennets14517633jennets
jennies143511623jennies
jesuits1436323jesuits
kebbies1537253kebbies
knits93914743_kn_its
legits71313003le_gits
lenis56326863len_i_s
lenite6719983len_ite
lenites7818443len_ites
lenity9612713len_ity
lentils73912973lentils
megabits1355793megabits
menhirs1235913menhirs
merits8320873me_rits
newbies12147423newbies
nits45741643__n_its
obits74617553__obits
orbits84211443_orbits
pandits103914213pandits
peewits12105873peewits
pencils113011773pencils
penis75129323pen_i_s
penlite9313243penlite
penlites10312273penlites
pennies94218813pennies
pennis84315743penni_s
pensils92811593pensils
penults937123penults
permits11314003permits
pewits112810683pe_wits
probits112712573probits
pundits10379293pundits
qubits173710353_qubits
rabbits11299863rabbits
rebaits9312573rebaits
rebids94015533re_bids
rebuts84015193re_buts
recits83621353re_cits
redbaits1135903redbaits
reedits8511743reedits
reemits9611303reemits
refits94017653re_fits
reknits1137073reknits
remits85622943re_mits
renails74917263renails
renests74014213renests
renigs74314593ren_igs
renins64526453ren_ins
rennets75212633rennets
rennins74013413rennins
rents55935183ren__ts
resits64725563re_sits
seniti64317223sen_iti
sennets73712583sennets
sennit63117923sennit_
sherbets1335213sherbets
snits54124833_sn_its
tenails73713923tenails
tenants7311013tenants
tenets65518953ten_ets
tenias64720073ten_ias
tennies73017973tennies
tennis64015303tenni_s
tennist72813113tennist
tennists8297793tennists
tenpins9410073tenpins
tensity1039103tensity
tents56434213ten__ts
tenuis64213083tenui_s
tenuity1037453tenuity
terbias9310743terbias
territs72714503territs
thermits1338513thermits
tidbits1035183tidbits
titbits935803titbits
turbits969233turbits
unfits93910293_unfits
units54923433_un_its
unwits9389893_unwits
venins93816703ven_ins
vents86125933ven__ts
verbids13259203verbids
weskits1434743weskits
xenias133712973xen_ias
zenith1839073zen_ith
zeniths1935153zen_iths

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.420425454.8
2DLD Change Limit1340272066.06322105.7
3Display Results2062060.0633269.8
 (SQL Overall)1786912066.54627297.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.