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

404 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
habited133788(None) 
abated95918452_abated
abided105313312_abided
babied114913512babi_ed
baited95319242ba_ited
cabined1239992cabined
cohabited1744022cohabited
debited113311622debited
gaited84416922ga_ited
habile11515212habile_
habit103027022habit__
habitan1236902habitan
habitat12411052habitat
habits113014652habit_s
habitude14264152habitude
habitue12266702habitue
habitues13306412habitues
habitus12338172habitus
hafted134713832ha_fted
hailed104122742ha_iled
haired105117172ha_ired
halite93624232halite_
halites103221192halites
halted105019602ha_lted
hanted104124312ha_nted
hasted105125282ha_sted
hated95734022ha__ted
hatted104921512ha_tted
haunted11399732haunted
inhabited1544672inhabited
labiated11109302labiated
orbited1037732orbited
rabbited1334762rabbited
waited103819772wa_ited
abased96514993_abased
abate76627843_abate_
abater85518123_abater
abates85825033_abates
abed79734133_ab__ed
abetted1058323_abetted
abide86223713_abide_
abider95314463_abider
abides94719893_abides
ablated102513443_ablated
abled86926833_ab_led
abluted10188363_abluted
aboded104912513_aboded
aborted10310423_aborted
abused95614273_abused
abutted1056983_abutted
acted88521733_a_cted
adhibited1642473adhibited
agisted938203_agisted
aided75828933_a_ided
ailed66240283_a_iled
aimed85626053_a_imed
aired66032923_a_ired
airted74214503_airted
alated75625153_alated
albite8313313albite_
albites9313203albites
alined75221403_alined
aliped95414283_aliped
anted66328243_a_nted
arabized2047173arabized
arbiter939933arbiter
ariled75620323_ariled
audited939033audited
aviated11310263_aviated
awaited1146963awaited
axised14438963_axised
axite125218253_axite_
axites134913833_axites
azoted16388593_azoted
babbitted1342953babbitted
babbled113612863babbled
babier103515573babi_er
babies106123653babi_es
bailed94726653ba_iled
baiter84422563ba_iter
barite84224813barite_
barites94322333barites
basined10310003basined
basted95227233ba_sted
bated85935533__bated
batiked1435963batiked
batted95623653ba_tted
bided95424963__bided
biked125320033__biked
biped104718833__biped
bite66547003__bite_
biter75030033__biter
bites75641173__bites
bitted94418483__bitted
bruited104110353bruited
cabbed135416263cab_bed
cabinet11318903cabinet
cabled114819873cab_led
canted94825783ca_nted
caried94528693cari_ed
carted98631443ca_rted
catted95422473ca_tted
caviled1348723caviled
cavitied14126813cavitied
chained133812693cha_ined
chaired134211243cha_ired
chaliced1637043chaliced
chanted134015953cha_nted
chapiter1536603chapiter
charioted1595873charioted
charted135116853cha_rted
chatted133411893cha_tted
chaunted1485603chaunted
cited84421953__cited
cohabiter1643963cohabiter
dabbed124416143dab_bed
dabbled133712073dabbled
dabster1036703dabster
dacite91115883dacite_
dacites101114593dacites
darted84620923da_rted
dated75530993da__ted
daunted93810193daunted
dauted84114933da_uted
dawted11489683da_wted
debated113916083debated
debuted11379333debuted
doited85016633_doited
edited83913673_edited
endited93512913endited
evited104013143_evited
excited1737853excited
exhibited2243303exhibited
exited144712523_exited
fabled124216383fab_led
faceted13509563faceted
fagoted1236073fagoted
failed105421603fa_iled
fainted114211723fainted
faired105915773fa_ired
faithed1437163fa_ithed
farted105121783fa_rted
fasted105320953fa_sted
fated95632133fa__ted
fatted105419843fa_tted
faulted11227723faulted
flited104616583_flited
fruited11389093fruited
gabbed125216893gab_bed
gabbled134112453gabbled
gabies93820733gabi_es
gabled105518453gab_led
gained84617463ga_ined
gaiter73819503ga_iter
garoted9710133garoted
gasted84821583ga_sted
gated75329773ga__ted
habitans1346623habitans
habitant1348673habitant
habitats1346733habitats
habiting1437533habiting
habitual1343493habitual
habituated1643053habituated
habitudes15253903habitudes
hacked164923513ha_cked
hackled173312493hackled
haded105227623ha__ded
hadith13312063hadit_h
hadiths1436023hadiths
haed86338583ha___ed
hafizes2235983hafizes
hafter124815883ha_fter
hagged124317703ha_gged
haggled13359283haggled
hailer94720343ha_iler
haled95335823ha__led
halid94424983hali__d
halide103417993halide_
halides113416663halides
halitus10339963halitus
halloed113314913halloed
haloed104717603ha_loed
halter94420883ha_lter
halved134813903ha_lved
hamate113319833hamate_
hamates122917683hamates
hamboned1637003hamboned
hammed144116973ha_mmed
hamster12810423hamster
handed114919983ha_nded
handled124114533handled
hanged114222403ha_nged
hanked144220603ha_nked
haplite12310703haplite_
haplites1339993haplites
happed144820103ha_pped
hapten115312983ha_pten
harbored1438643harbored
hared95742183ha__red
harked145422553ha_rked
harmed125218833ha_rmed
harped124418403ha_rped
harried113815543harried
hashed136021943ha_shed
hasped125014443ha_sped
hassled11358303hassled
haste85927863ha_ste_
hasten95718563ha_sten
hastes95727073ha_stes
hastier103916623hastier
hatched163414463hatched
hate78450173ha__te_
hater85034753ha__ter
hates86742573ha__tes
hatred104814333ha_tred
hatter94724873ha_tter
hauled104415213ha_uled
haunter103111153haunter
haute89521613ha_ute_
havened14429243havened
havered144011453havered
hawed126025423ha__wed
hawked174712673ha_wked
hayed125822013ha__yed
hayseed1435633hayseed
hazed185222203ha__zed
hazier184712403hazi_er
hearted113314033hearted
heated104525593h_eated
hefted134911423h_efted
heiled104415613h_eiled
heired103813043h_eired
heisted113210653heisted
hented104218753h_ented
hided105222443h__ided
hied85434043h__i_ed
highted152710163highted
hiked135919203h__iked
hilted104016043h_ilted
hinted104318323h_inted
hired95226263h__ired
histed104420243h_isted
hived125217913h__ived
hobbed144114303hob_bed
hobbled153310783hobbled
hoboed124511683hob_oed
hogtied12226653hogtied
hoised105117433h_oised
hoisted113411293hoisted
honied104818393honi_ed
hooted104422663h_ooted
hosted105020343h_osted
hotted104319943h_otted
hunted104417013h_unted
hutted104616333h_utted
hyalite13229473hyalite_
hyalites14208833hyalites
ignited9137623ignited
imbibed1433733imbibed
incited103314623incited
indited93515023indited
inhabiter1444483inhabiter
inhibited1544763inhibited
invited113612463invited
jabbed184213483jab_bed
jailed144917423ja_iled
jaunted15418563jaunted
kibitzed2442043kibitzed
kited105120093__kited
labeled102510563labeled
labiate91313573labiate_
labiates101011513labiates
labile8315223labile_
labored102810253labored
laired75216813la_ired
lanated8313203lanated
lariated91212063lariated
lasted74323603la_sted
lated65240673la__ted
lazied164610653lazi_ed
lenited8812433lenited
limited102310233limited
lobated102610943lobated
mailed95326753ma_iled
maimed114812663ma_imed
malted94819863ma_lted
marted94425213ma_rted
masted94025803ma_sted
mated85537783ma__ted
matted94521413ma_tted
merited10313853merited
nabbed115113613nab_bed
nailed74021493na_iled
orbiter937853orbiter
paiked135113433pa_iked
pained95622853pa_ined
painted104214633painted
paired95017523pa_ired
panted95024823pa_nted
parted94228683pa_rted
partied103516553partied
pasted94426903pa_sted
pated85237843pa__ted
patined105114783patined
patted94724683pa_tted
plaited103713893plaited
posited10511493posited
quoited1756403quoited
rabbeted1334443rabbeted
rabbiter1234673rabbiter
rabbled123514423rabbled
rabid84520783rabi__d
rabies85226023rabi_es
radiated102512593radiated
radioed939673radioed
rafted104714703ra_fted
raided85017703ra_ided
railed74727543ra_iled
rained75024603ra_ined
raised76120333ra_ised
ranted74324703ra_nted
rated65441383ra__ted
ratite65022423ratite_
ratites74920683ratites
ratted74923343ra_tted
ravined115411823ravined
rebaited11410543rebaited
rebated103619703rebated
recited104319103recited
resited85122423resited
rubied94312413rubi_ed
sabbed114518083sab_bed
sabed86526813sab__ed
sabered103213023sabered
sabine84020393sabine_
sabines94318483sabines
sabred95916533sab_red
sailed74327763sa_iled
sained75424243sa_ined
sainted84114243sainted
salted74121203sa_lted
saluted84511713saluted
samite83020603samite_
samites93118713samites
sated66238533sa__ted
satiated9311603satiated
sauted74119603sa_uted
shafted14288813sha_fted
sited65130743__sited
skited114313483_skited
sopited104211063sopited
spited94820443_spited
subitem1138553subitem
suited74019423_suited
tabbed114215363tab_bed
tabbied12297793tabbied
tabered103311593tabered
tabid84418263tabi__d
tabled94020043tab_led
tableted1137533tableted
tabooed10267383tabooed
tabored102810563tabored
tabued94310403tab_ued
tailed74424663ta_iled
tainted83512423tainted
taliped1078203taliped
tarted74923373ta_rted
tasted74123973ta_sted
tatted74920533ta_tted
taunted84310963taunted
tauted75317113ta_uted
taxied14509373taxi_ed
taxite13511303taxite_
taxites1449673taxites
toited74016753_toited
unabated11310133unabated
unbated103317733unbated
unbitted1138213unbitted
united74421543_united
vacated1349353vacated
vailed104619293va_iled
valeted1139013valeted
vanitied12138213vanitied
variated121211393variated
varied104817863vari_ed
vatted104214733va_tted
vaulted11307193vaulted
vaunted11438863vaunted
visited1168773visited
vomited1337253vomited
wabbled153311443wabbled
wafted134012143wa_fted
waifed134011033wa_ifed
wailed104823593wa_iled
waired106015833wa_ired
waisted114210943waisted
waiter94321253wa_iter
waived134511283wa_ived
wanted104319723wa_nted
warted104223233wa_rted
wasted104423023wa_sted
whited134814083_whited
wited94727143__wited
yachted1634853yachted

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.500357382.0
2DLD Change Limit1340274046.89019452.4
3Display Results4044040.1732335.3
 (SQL Overall)1786914047.56323627.0
 
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.