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

194 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
ideation931049(None) 
ideations1039901ideations
adnation9310782adnation
creation102816512creation
delation92318082_delation
dilation92215462dilation
ideating10311702ideating
ideational1146502ideational
ideative1238572ideative
illation8311942illation
indention1049512indention
indexation1846342indexation
iodation9310382iodation
iteration9515032iteration
lineation9310762lineation
nidation9410582nid_ation
sedation9312452sedation
ablation10312433ablation
adaption1145643adaption
addition1096893addition
ademption1443493ademption
adnations1039753adnations
adoption1146083adoption
adoration10311313adoration
adulation10311013adulation
advection1545553advection
aeration8319933aeration
agnation9311723agnation
alation72920553_alation
aviation11312743aviation
bijection20134793bijection
bilection13156803bilection
bisection13136983bisection
caseation1199513caseation
cation83925503__cation
chelation1439963chelation
ciliation111112493ciliation
citation10314363citation
conation101420883conation
creatin93618133creati_n
creations112614543creations
cremation13511643cremation
crenation11412923crenation
deacon9510423_dea_con
dealation10313003_dealation
deflation13310653_deflation
delations102616593_delations
deletion92011973_deletion
demotion1169073_demotion
dentation10315243_dentation
dentin73919573_denti_n
detain74617383_detai_n
deviation13312393_deviation
devotion1256763_devotion
diatron839283_diatron
dictation12810563dictation
diction102313053_diction
digestion1146573digestion
dilations102614453dilations
dilution9239143dilution
direction1289783direction
donation91513783donation
dotation91412733dotation
duration9312693duration
edition8310853ed_ition
education12310203education
eduction1169053eduction
egestion946863egestion
ejection172510043ejection
elation73620453_elation
election102015353election
elevation1239233elevation
enation73419233_enation
equation17310483equation
erection102115513erection
evection131910833evection
exertion15310083exertion
federation1449573federation
fetation11613143fetation
filiation121110243filiation
fixation1837073fixation
flection13239563flection
gelation93014433gelation
gyration1237763gyration
halation11313853halation
himation1339753himation
hydration1646073hydration
idealise938053idealise
idealism1147013idealism
idealist9310653idealist
ideality1247153ideality
idealize1847873idealize
ideate7313683ideat__e
ideated9310973ideat_ed
ideates8313733ideat_es
identic1038043identi_c
identify1544133identify
identity1245373identity
ignition946533ignition
illations9311393illations
imitation11510853imitation
impaction1545733impaction
inaction1039623inaction
incaution1146583incaution
inception1348693inception
indagation1246153indagation
indentation1248373indentation
indentions1149063indentions
indexations1946023indexations
indication13312033indication
indiction1239813indiction
induction1248983induction
induration11410613induration
infection14410473infection
inflation12311093inflation
ingestion10137483ingestion
injection1838653injection
insertion9410593insertion
intention9412013intention
invasion11115473invasion
invention1248333invention
iodations1039113iodations
iodination1159983iodination
isatin6412213i_sati_n
isolation9311643isolation
iterations10413823iterations
kation104315683__kation
lavation1139973lavation
laxation1538423laxation
lection92614863_lection
legation92412933legation
libation102411363libation
liberation1269993liberation
libration111510163libration
ligation92313093ligation
lineations1039543lineations
liquation1846553liquation
literation10511413literation
lobation102110553lobation
location102113913location
lunation8311923lunation
luxation1538233luxation
mediation12312293mediation
mention9314373_mention
midsection1544433midsection
migration12179703migration
moderation1348653moderation
mutation101412883mutation
natation81513933natation
nation64322803__nation
negation92913023negation
nictation1189273nictation
nidations1039213nid_ations
nitration9313443nitration
notation81414603notation
novation111710013novation
nutation81513103nutation
oblation1039863oblation
operation11314003operation
oration71617713_oration
ovation101510023_ovation
oxidation1746323oxid_ation
pinnation1138013pinnation
potation101716783potation
predation12313463predation
pupation1269503pupation
question1745823question
radiation10313393radiation
ration64226013__ration
reaction10612603_reaction
redaction1259663redaction
relation82619773relation
rogation91612053rogation
rotation81615453rotation
section92515663_section
sedations10311253sedations
sedition939333sedition
siltation939213siltation
sinuation9310413sinuation
situation949423situation
solation8916153solation
station72717243_station
sudation9310803sudation
taxation1537993taxation
titration9310543titration
vacation131911893vacation
venation11513503venation
vexation1838783vexation
vibration14138203vibration
violation1238443violation
vitiation1239563vitiation
vocation132311983vocation
zeatin15412823_zeati_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.406440125.6
2DLD Change Limit1461621947.31319986.6
3Display Results1941940.0802425.0
 (SQL Overall)1786911947.79922912.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.