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

157 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
habitus1233817(None) 
habits113014651habit_s
habitue12266701habitue
habitues13306411habitues
halitus10339961halitus
cubitus11346782cubitus
habit103027022habit__
habitan1236902habitan
habitans1346622habitans
habitat12411052habitat
habitats1346732habitats
habited1337882habited
habitual1343492habitual
habitude14264152habitude
habitudes15253902habitudes
habus106317142hab__us
hadiths1436022hadiths
haikus13538292ha_ikus
halites103221192halites
jabirus1694572jabirus
manitus9310922manitus
abacus10349763_abacus
abates85825033_abates
abatis84317933_abatis
abets75621673_abet_s
abides94719893_abides
abortus9397913_abortus
abuts75417073_abut_s
acinus8311253_acinus
adieus739633_adieus
adits66523713_adit_s
agitas7310593_agitas
aits46355533_a_it_s
albites9313203albites
ambits103713413ambit_s
amicus103810003_amicus
animus84211613_animus
arbutus944843arbutus
axites134913833_axites
babbitts1144023babbitts
babies106123653babi_es
babirusa1241923babirusa
babus95620333bab__us
baits76630583ba_it_s
barites94322333barites
bites75641173__bites
bits66148163__bit_s
bitts75022593__bitts
cabins104418923cabi_ns
cactus104912233ca_ctus
caestus947773caestus
cantus85117763ca_ntus
carious93320283carious
caritas93316953caritas
casitas93312043casitas
cohabits1545413cohabit_s
coitus8511893_coitus
cubits103714033cubit_s
dacites101114593dacites
davits104012363davit_s
debits94214503debit_s
dubious1036893dubious
faiths124610273fa_iths
fajitas1734253fajitas
gabies93820733gabi_es
gabions102410053gabions
gaits65726013ga_it_s
gambits12399723gambit_s
habile11515213habi_le
habitant1348673habitant
habitants1445123habitants
habiting1437533habiting
habituate1443923habituate
habituates1543633habituates
haboobs1495463haboobs
habu97325483hab__u_
hadith13312063hadit_h
haets86525123ha_et_s
haffits1636193haffit_s
hafizes2235983hafizes
hafts116219463ha_ft_s
hagbuts1354933hagbut_s
haiks125120933ha_i_ks
haiku126113693ha_iku_
hails85231643ha_i_ls
haints94417583ha_ints
hairs86225173ha_i_rs
hajis156716283haji__s
hakims1537303haki_ms
hakus125114113ha__kus
halibut1289053halibut
halibuts1364443halibuts
halides113416663halides
halids104016133hali_ds
halite93624233halit_e
halituses1245573halituses
halts85230103ha_lt_s
hamates122917683hamates
hamulus1235323hamulus
hants86335403ha_nt_s
haplites1339993haplites
harts88441593ha_rt_s
hastes95727073ha_stes
hates86742573ha__tes
hats76858253ha__t_s
haunts95614393haunt_s
haviors1347383haviors
haviour1354823haviour
haviours1443843haviours
hayings14379393hayings
hazings20378343hazings
henbits12177003henbit_s
hiatus938223h_iatus
hibiscus1541583hibiscus
hilus84817643h__ilus
hits75545133h__it_s
hobbits14317553hobbit_s
hyalites14208833hyalites
inhabits1355473inhabit_s
jabiru15125513jabiru_
jabots1538883jabot_s
kabikis1243863kabikis
labials9299873labials
labiates101011513labiates
labium10410243labi_um
manitos9314053manitos
manitous1039173manitous
manitu8315823manitu_
nabis76020583nabi__s
nairus639143na_irus
obits74617553_obit_s
orbits84211443orbit_s
peritus9311803peritus
qubits173710353qubit_s
rabatos93010903rabatos
rabats83116223rabat_s
rabbits11299863rabbit_s
rabies85226023rabi_es
radius73914873radi_us
raitas64417673ra_itas
ratites74920683ratites
rubious938283rubious
sabines94318483sabines
sabins85521983sabi_ns
sabirs85414633sabi_rs
sabots8314703sabot_s
samites93118713samites
sanious7514103sanious
scabious1246593scabious
situs55019233__situs
tabus74820923tab__us
taxites1449673taxites
various103113103various
vatus86114643va__tus
vomitus12215743vomitus
waits88333523wa_it_s
wapitis1236473wapitis

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.406440125.6
2DLD Change Limit1340271575.73323378.2
3Display Results1571570.0632492.1
 (SQL Overall)1786911576.20228811.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.