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

349 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
fixated183553(None) 
fixate1638731fixate_
fixates1737391fixates
dilated93115822dilated
fated95632132f__ated
fileted1159092fileted
filiated12610082filiated
fisted104218702fi_sted
fitted104716662fi_tted
fixatif2054632fixatif
fixed165416952fix__ed
floated113312702floated
ligated92414142ligated
luxated1535712luxated
nidated939862nidated
pirated102515612pirated
abated95918453_abated
ablated102513443ablated
aerated85322383aerated
agitated1038413agitated
airted74214503ai_rted
alated75625153_alated
animated111612373animated
ansated84214003ansated
aurated83817793aurated
aviated11310263aviated
bated85935533__bated
belated103520013belated
berated104422133berated
biased94012223bi_ased
bighted142810923bighted
bigoted11258403bigoted
bilsted1038033bilsted
binate8419773binate_
biparted1335133biparted
bitted94418483bi_tted
bleated104015973bleated
bloated104513433bloated
boated94221973_boated
borated104116363borated
cerated103922473cerated
cheated134416353cheated
ciliated11510953ciliated
cisted95217523ci_sted
cited84421953ci__ted
citrated112712253citrated
cleated103417853cleated
coated94927043_coated
crated94827773_crated
created104323463created
curated104717583curated
dated75530993__dated
debated113916083debated
delated93722873delated
derated93623503derated
dialed84716453di_aled
dictated1239203dictated
dieted83115493di_eted
dighted132511493dighted
dilate73220693dilate_
dilater83515653dilater
dilates83220663dilates
diluted9248933diluted
dinted84419843di_nted
disrated10915573disrated
doated84118183_doated
donated93513863donated
elated74725823_elated
epilated11310753epilated
equated171910403equated
estated83715573estated
exacted1737303_exacted
exalted1537393_exalted
exapted1736073_exapted
existed1538473existed
exited144712523_exited
faced117727653f__aced
faceted13509573faceted
faded105025243f__aded
fagoted1236073fagoted
fainted114211723fainted
faked135225483f__aked
falcated1438483falcated
famed115928343f__amed
fared95842343f__ared
farted105121783f_arted
fasted105320953f_asted
fate75444283f__ate_
fates85139233f__ates
fatted105419843f_atted
faulted11227723faulted
faxed166220533f__axed
fayed126422153f__ayed
fazed186222963f__azed
feared106320433f_eared
feased105718713f_eased
feasted11310843feasted
feater95224053f_eater
feazed195112633f_eazed
feinted11379623feinted
fellated1239563fellated
felted103714653f_elted
feted94420933f__eted
fetted104817893f_etted
fiat76646653fi_at__
fiats85324483fi_at_s
fibbed144011553fi_bbed
fibered1337643fibered
fibster12146533fibster
fiddled13329633fiddled
fidged124610933fi_dged
fidgeted1443893fidgeted
fielded12206813fielded
fifed125115973fi__fed
figeater1236953figeater
figged124013893fi_gged
fighter143010773fighter
figured12196473figured
filaree10611223filaree
filched16307423filched
filed95331903fi__led
filiate10414233filiate_
filiates11412663filiates
filled104922263fi_lled
filleted1236603filleted
filmed124610363fi_lmed
filter94517633fi_lter
filtrated1345963filtrated
finagled13205293finagled
finale94116763finale_
finales104016013finales
financed1435123financed
fined94930503fi__ned
finialed1255503finialed
finite9316823finite_
finites10315923finites
finked144214623fi_nked
finned104114603fi_nned
fired94829743fi__red
firmed125411883fi_rmed
fished134316313fi_shed
fissate103010033fissate_
fitter94120033fi_tter
fixable19218193fixable
fixatifs2162073fixatifs
fixating1936183fixating
fixation1837073fixation
fixative2145083fixative
fixatives2243353fixatives
fixer154717833fix__er
fixes154723593fix__es
fixit154819303fixit__
fixities1838223fixities
fixity19427813fixit_y
fixt1410729723fix_t__
fixure16256543fixure_
fixures17596063fixures
fizzed18369443fi_zzed
fizzled19357273fizzled
flaked144715653f_laked
flamed124618973f_lamed
flared105317603f_lared
flatbed13397983f_latbed
flatted114012943flatted
flawed134712723f_lawed
flayed134414053f_layed
fleeted113310233fleeted
flighted1646973flighted
flinted114411893flinted
flirted11428673flirted
flited104616583f_lited
flitted114011643flitted
floatel10308013floatel
floater104413353floater
flouted113210813flouted
fluted104917163f_luted
flyted13378773f_lyted
foaled104515963f_oaled
foamed126014403f_oamed
foisted113210603foisted
folate93320393folate_
folates103218453folates
foliated1249913foliated
footed104418623f_ooted
foraged124812283foraged
forayed14368593forayed
foveated1536293foveated
foxed165115213fox__ed
fracted1339373fracted
framed125116523f_ramed
frater94520593f_rater
frayed135012163f_rayed
freaked15399703freaked
fretted113411853fretted
frigate11311063frigate_
frigates12310933frigates
frighted1657173frighted
fritted113611333fritted
fronted114011273fronted
frosted113211883frosted
fruited11389093fruited
fumigated1644723fumigated
furcated1437593furcated
gated75329773__gated
gelated93615643gelated
gifted114510703gi_fted
girted83912873gi_rted
gitted84015053gi_tted
gloated93511533gloated
grated84523923_grated
gyrated12428413gyrated
hated95734023__hated
heated104525593_heated
highted152710163highted
hilted104016043hi_lted
hinted104318323hi_nted
histed104420243hi_sted
ideated9310973ideated
imaged1097763_imaged
imitated1138263imitated
iodated9310023iodated
irate55627983_irate_
irater65218353_irater
jilted144111353ji_lted
kilted113613833ki_lted
kited105120103ki__ted
kitted115114833ki_tted
lanated8313203lanated
lated65240673__lated
legated92513983legated
librated113110313librated
lichted13268803lichted
lifted104413523li_fted
ligate72519253ligate_
ligates82318383ligates
lighted122913503lighted
lilted73715373li_lted
limited102310233limited
lineated9711063lineated
linted74021823li_nted
liquated1835493liquated
listed74322833li_sted
lobated102610943lobated
located103114183located
lunated8310823lunated
luxate1338083luxate_
luxates1436973luxates
lyrated11388473lyrated
mated85537783__mated
meated94222403_meated
migrated121110513migrated
milted93919943mi_lted
minted94220583mi_nted
minuted10329503minuted
misacted1338673misacted
misate81222693misate_
misdated121211123misdated
mismated131111333mismated
misrated111315383misrated
misted93625823mi_sted
mixed155717253mix__ed
moated94819003_moated
mutated102712253mutated
negated93413233negated
nictated1137793nictated
nidate7313783nidate_
nidates8311893nidates
nitrated92213153nitrated
nixed135714223nix__ed
notated82713663notated
nutated83113423nutated
opiated1039483opiated
orated74221503_orated
oxidated1745033oxidated
pated85237843__pated
picoted1239213picoted
picrated132110113picrated
pileated112711133pileated
piloted10310323piloted
pinnated11338553pinnated
pirate82322883pirate_
pirates93020333pirates
pitted94319593pi_tted
pivoted1336513pivoted
pixilated1944543pixilated
plated95225773_plated
pleated103816633pleated
plicated13310643plicated
prated94924923_prated
pupated12319353pupated
rated65441383__rated
rebated103619703rebated
redated93120923redated
related83327573related
remated103522473remated
rifted104115313ri_fted
righted122912143righted
rioted73416373ri_oted
rivaled1138933rivaled
riveted11258573riveted
rotated82715293rotated
ruinated939523ruinated
sated66238533__sated
seated75131063_seated
sedated93714353sedated
sifted104313673si_fted
sighted123111523sighted
silted74020013si_lted
sinuated938413sinuated
sited65130743si__ted
situated938033situated
sixte126216583six_te_
sixtes133612403six_tes
skated114414883_skated
slated75028313_slated
solated83618023solated
spicated13309903spicated
stated75427833_stated
sweated113411543sweated
teated74924023_teated
tilted74616863ti_lted
tincted1037273tincted
tinted74419533ti_nted
titrated92611683titrated
togated94410663togated
treated83618703treated
unbated103317733unbated
undated93118463undated
ungated92717213ungated
unmated103317023unmated
unrated82621553unrated
unsated83419933unsated
updated11369423updated
uprated103213323uprated
urinated9311613urinated
vacated1349353vacated
vialed105112593vi_aled
vibrated14228393vibrated
violated1237883violated
visaed104110503visa_ed
visaged1235683visaged
visited1168773visited
vistaed1138023vistaed
vitiated12289223vitiated
wilted103915713wi_lted
wisted104120273wi_sted
wited94727143wi__ted
witted104216813wi_tted
zonated173310533zonated

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.796224486.2
2DLD Change Limit1340273496.81019680.9
3Display Results3493490.1262769.8
 (SQL Overall)1786913497.73223110.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.