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

269 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
halitus1033996(None) 
habitus12338171habitus
halites103221191halites
habits113014652habit_s
habitue12266702habitue
habitues13306412habitues
hadiths1436022hadiths
haikus13538292ha_ikus
halibut1289052halibut
halibuts1364442halibuts
halides113416662halides
halids104016132hali_ds
halite93624232halit_e
halituses1245572halituses
halts85230102hal_t_s
haplites1339992haplites
hyalites14208832hyalites
manitus9310922manitus
aaliis6312903aali_is
acinus8311253_acinus
adieus739633_adieus
adits66523713_adit_s
agitas7310593_agitas
aits46355533_a_it_s
alates64833963_alates
albites9313203_albites
alias55834603_ali_as
alibis8311073_alibis
aliens65619213_aliens
alifs86121263_ali_fs
aligns75312953_aligns
alines65735223_alines
alit46155693_alit__
aliyas93911803_aliyas
aliyos9349533_aliyos
altos55822953_al_tos
alts46639903_al_t_s
amicus103810003_amicus
animus84211613_animus
aplites9314933aplites
axites134913833_axites
baits76630583ba_it_s
balatas9311833balatas
barites94322333barites
bilious9310933bilious
blites84721213_blites
boletus948643boletus
cactus104912233ca_ctus
caestus947773caestus
calamus1139243calamus
calathus1345023calathus
calcites12313003calcites
calices114321693calices
calicos113913493calicos
califs114915893cali_fs
caliphs1436753caliphs
callous93516603callous
callus85317073cal_lus
cantus85117763ca_ntus
carious93320283carious
caritas93316953caritas
casitas93312043casitas
chalets122813473chalet_s
chalices15310813chalices
coitus8511893_coitus
colitis92617353colitis
cubitus11346783cubitus
cultus85110733cul_tus
dacites101114593dacites
daleths1135323daleths
davits104012363davit_s
egalites9310503egalites
elites66027123_elites
eoliths10318573eoliths
faiths124610273fa_iths
fajitas1734253fajitas
flatus94310783_flatus
flites95122443_flites
flits85625223_flit_s
folious103710733folious
gaits65726013ga_it_s
galiots82311323galiots
gallous82813953gallous
gallus74313203gal_lus
habit103027023habit__
habitan1236903habitan
habitans1346623habitans
habitat12411053habitat
habitats1346733habitats
habited1337883habited
habitual1343493habitual
habitude14264153habitude
habitudes15253903habitudes
habus106317143ha__bus
hadith13312063hadit_h
haets86525123ha_et_s
haffits1636193haffit_s
hafizes2235983hafizes
hafts116219463ha_ft_s
hagbuts1354933hagbuts
haiks125120933ha_i_ks
haiku126113693ha_iku_
hailers104017263hailers
hails85231643ha_i_ls
haints94417583ha_ints
hairs86225173ha_i_rs
hajis156716283haji__s
hakims1537303haki_ms
hakus125114113ha__kus
halalas104214083halalas
halals95018313hal_als
halers94926913hal_ers
haleru94212073haleru_
hales85449843hal__es
halid94424983hali__d
halide103417993hali_de
halidom1386443halidom
halidoms1485823halidoms
haling104229783hali_ng
halitoses1246603halitoses
halitosis1245203halitosis
hallahs133912463hallahs
hallels103310133hallels
halloas104318463halloas
halloes104021523halloes
halloos103716743halloos
hallos95425103hal_los
hallows134417393hallows
halls85633783hal__ls
hallux1637363hal_lux
halmas117017893hal_mas
halms105225213hal__ms
haloes94623863hal_oes
haloids113012553haloids
halons95720713hal_ons
halos85230253hal__os
halt76056303hal_t__
halted105019603hal_ted
halter94420883hal_ter
halters104619803halters
halting114419073halting
halutz1868853halut_z
halvahs16417533halvahs
halvas124714173hal_vas
halvers133311423halvers
halves124717093hal_ves
hamates122917683hamates
hamlets123211403hamlet_s
hamulus1235323hamulus
hants86335403ha_nt_s
haplite12310703haplit_e
harlots103413293harlot_s
harts88441593ha_rt_s
haslets102510863haslet_s
hastes95727073ha_stes
hates86742573ha__tes
hats76858253ha__t_s
hauliers1176713hauliers
haunts95614393haunt_s
haviors1347383haviors
haviour1354823haviour
haviours1443843haviours
hayings14379393hayings
hazings20378343hazings
healths13478753heal_ths
helices12313723helices
helios94816633heli_os
helium112311253heli_um
heliums12188303heliums
helixes1739133helixes
helots95217703helot_s
hiatus938223h_iatus
hilts86924413hil_t_s
hilus84817643h__ilus
hits75545133h__it_s
holibut1297483holibut
holibuts1363953holibuts
holies94630033holi_es
holisms123811113holisms
holists104413963holists
holts85627913hol_t_s
hoplites13310543hoplites
hyalines14169333hyalines
hyalins13229273hyali_ns
hyalite13229473hyalit_e
illites72415013illites
iolites73819483iolites
jabirus1694573jabirus
kalians11310183kalians
kalifs134410983kali_fs
kaliphs1634293kaliphs
kalium1239473kali_um
kaliums1336603kaliums
khalifas1842513khalifas
khalifs1754073khali_fs
lalique1644423lalique
laliques1744833laliques
lieus56218483__lieus
litas54923773__litas
litmus836323__litmus
lits46252493__lit_s
litu47631563__litu_
lotus55718063__lotus
malates93522603malates
malices114316623malices
maligns1038133maligns
malines93625603malines
malleus92911313malleus
malts76331753mal_t_s
manitos9314053manitos
manitous1039173manitous
manitu8315823manitu_
marlites103415263marlites
milieus939803milieus
nairus639143na_irus
oolites72817843oolites
ooliths10268323ooliths
palates93624933palates
palets85122313palet_s
palings103915823palings
palpus104210283pal_pus
pelites93821993pelites
peritus9311803peritus
phallus1236063phal_lus
plaits83816473plait_s
radius73914873radi_us
railbus934413railbus
raitas64417673ra_itas
ratites74920683ratites
salinas73116093salinas
salines74029413salines
salivas10309603salivas
salties73725773salties
salts55431883sal_t_s
salutes73716253salutes
samites93118713samites
sanious7514103sanious
situs55019233__situs
slits56128853_slit_s
solidus8338113solidus
splits85416413split_s
talcous939483talcous
talions7314113talions
talipes9611603talipes
talliths11377433talliths
tallits73215993tallit_s
talus55423263tal__us
taxites1449673taxites
thalamus1343603thalamus
thallious1243273thallious
thallous1136523thallous
thallus1035603thal_lus
thelitis1147513thelitis
uralites82112723uralites
valets93715623valet_s
valgus1047103val_gus
valines104520213valines
valises103516263valises
valutas1036533valutas
various103113103various
vatus86114643va__tus
velites103417303velites
vomitus12215743vomitus
waits88333523wa_it_s
walies95324523wali_es
walnuts1033843walnuts
walrus956433wal_rus
wapitis1236473wapitis
whalings15256763whalings

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.406440125.6
2DLD Change Limit1340272696.62620227.4
3Display Results2692690.0932892.5
 (SQL Overall)1786912697.12525079.4
 
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.