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

229 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
fetation1161314(None) 
fetations12511381fetations
aeration8319932aeration
betatron1045222betatron
citation10314362citation
delation92318082delation
dentation10315242dentation
dotation91412732dotation
elation73620452_elation
enation73419232_enation
fellation1238842fellation
fixation1837072fixation
flotation1267812flotation
gelation93014432gelation
gestation10310662gestation
legation92412932legation
mentation11313982mentation
mutation101412882mutation
natation81513932natation
negation92913022negation
notation81414602notation
nutation81513102nutation
peltation11312962peltation
petition10711752petition
potation101716782potation
relation82619772relation
restation9316912restation
rotation81615452rotation
sedation9312452sedation
station72717242_station
venation11513502venation
vexation1838782vexation
ablation10312433ablation
actuation11310333actuation
adnation9310783adnation
aerations9317903aerations
affectation1943843affectation
agitation10311223agitation
agnation9311723agnation
alation72920553_alation
aviation11312743aviation
betatrons1145083betatrons
bevatron1343883bevatron
cation83925503__cation
ceratin93020163cerati_n
cessation1176853cessation
chelation1439963chelation
citations11312503citations
conation101420883conation
creation102816513creation
cremation13511643cremation
crenation11412923crenation
dealation10313003dealation
defecation1679803defecation
deflation13310653deflation
delations102616593delations
deletion92011973deletion
demotion1169073demotion
denotation11311083denotation
dentations11413633dentations
dentition1049633dentition
deputation1339393deputation
detain74617383deta_i_n
detection121310413detection
detention10169543detention
detonation11310943detonation
detraction13138583detraction
detrition1049133detrition
deviation13312393deviation
devotion1256763devotion
dictation12810563dictation
dilation92215463dilation
donation91513783donation
dotations101411633dotations
duration9312693duration
edition8310853_edition
elations83719123_elations
elevation1239233elevation
elution72913823_elution
emotion9711303_emotion
enations83316903_enations
equation17310483equation
erasion7311963_erasion
etalon648973_eta_lon
etamin81311853_etami_n
etatism9610293_etatism
etatist7415033_etatist
ethion938813_et_hion
evasion1036753_evasion
exaction1738953_exaction
faction122613333f_action
fanion94514323f__anion
federation1449573federation
fellatio1145683fellatio_
fellations1338063fellations
fellatios1245503fellatios
fenthion1444613fenthion
fermion1236763fe_rmion
festoon1037673fe_stoon
fetting113517873fet_ting
fiction122010733f_iction
filiation121110243filiation
filtration1346433filtration
fixations1936353fixations
flatiron1144623f_latiron
flection13239563flection
flirtation1354823flirtation
floatation1344683floatation
flotations1366873flotations
foliation121110793foliation
fomentation1647713fomentation
forestation1447003forestation
formation1439423formation
fraction1359483fraction
friction1347913friction
fruition11106103fruition
function1337843function
furcation1448353furcation
gelatin83514733gelati_n
gelations102513093gelations
gemmation1445963gemmation
gestations1139773gestations
gustation1047963gustation
guttation1046173guttation
gyration1237763gyration
halation11313853halation
hebetation1557093hebetation
hematin121516023hemati_n
hesitation1349633hesitation
himation1339753himation
ideation9310493ideation
illation8311943illation
imitation11510853imitation
infestation1447043infestation
iodation9310383iodation
iteration9515033iteration
jactation1838143jactation
jettison1542503jet_tison
jetton1338033jet_t_on
kation104315683__kation
keratin113314153kerati_n
lactation11310813lactation
lavation1139973lavation
laxation1538423laxation
lection92614863le_ction
legations102711923legations
lenition8310083lenition
levitation1349443levitation
libation102411363libation
ligation92313093ligation
lobation102110553lobation
location102113913location
lunation8311923lunation
luxation1538233luxation
mediation12312293mediation
meditation13410743meditation
megaton10269853megat_on
mentations12312583mentations
mention9314373me_ntion
metazoon1944053metazoon
mutations111211453mutations
natations91412493natations
nation64322803__nation
negations102811963negations
negaton8299143negat_on
negatron9335993negatron
nervation12610243nervation
nictation1189273nictation
nidation9410583nidation
nitration9313443nitration
notations91512973notations
novation111710013novation
nutations91411763nutations
oblation1039863oblation
operation11314003operation
oration71617713_oration
ovation101510023_ovation
peltations12311553peltations
petitions11511083petitions
potations111615073potations
predation12313463predation
pupation1269503pupation
quotation18146973quotation
ration64226013__ration
reaction10612603reaction
recaution1148093recaution
recitation12315943recitation
redaction1259663redaction
reflation12412333reflation
refutation1349913refutation
relations92418333relations
remotion10410233remotion
reputation12411883reputation
restations10315843restations
retain64523283reta_i_n
retention91611483retention
retortion949673retortion
retraction121310533retraction
rogation91612053rogation
rotations91613843rotations
saltation9312003saltation
satiation9313433satiation
section92515663se_ction
sedations10311253sedations
sedition939333sedition
sensation9510583sensation
seriation9318063seriation
serration9414063serration
siltation939213siltation
situation949423situation
solation8916153solation
statin63921473_stati_n
stations82415223_stations
sudation9310803sudation
taction93213023__taction
talion6317713__talion
taxation1537993taxation
temptation1446383temptation
tevatron1143973tevatron
titration9310543titration
vacation131911893vacation
vegetation1448213vegetation
venations12311723venations
vernation12311083vernation
vexations1937753vexations
vitiation1239563vitiation
vocation132311983vocation
zeatin15412823ze_ati_n
zonation171410723zonation

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622297.23320207.7
3Display Results2292290.0932462.4
 (SQL Overall)1786912297.48223882.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.