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

109 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
auditions107875(None) 
additions1186331additions
audition979171audition_
addictions14125362addictions
addition1096892addition_
ambitions1346342ambitions
auctions104012142au_ctions
auditing1039032auditi_ng
auditioned1243402auditioned
auditives1345722auditives
auditors947612audit_ors
caudations13108222caudations
editions9310402_editions
eruditions1146102eruditions
laudations1146842laudations
munitions1138172munitions
punitions1137922punitions
seditions1039012seditions
sudations1039902sudations
tuitions838282tu_itions
abdications1657653abdications
abductions15125383abductions
ablations11311513ablations
ablutions1146603ablutions
abolitions1246653abolitions
abortions1147783abortions
actions94218513a__ctions
adaptions1245223adaptions
addiction13146013addiction_
additional1244643additional
additives1444443additives
adductions14104953adductions
adnations1039753adnations
adoptions1245783adoptions
adulations11310123adulations
aerations9317903aerations
agnations10310033agnations
alations82518893a_lations
ambition1246563ambition_
ambitious1344613ambitious
ammunitions15113653ammunitions
amotions1069843a_motions
andirons948423andi_rons
attritions1066793attritions
auction93412933au_ction_
audacious1244673audacious
audios72312283aud__io_s
audiphone1553083audiphone
audiphones1653213audiphones
auditees946463audit_ees
auditioning1352703auditioning
auditive1247163auditi_ve
auditor837313audit_o_r
auditory1245703audit_ory
audits72814113audit___s
aviations12311553aviations
caudation1269993caudation_
causations1268143causations
cautions103313183cau__tions
coitions10312853_coitions
conditions13410103conditions
dictions111812673__dictions
durations10311463durations
edition8310853_edition_
eductions1268773eductions
erudition1046173erudition_
exudations18107073exudations
fruitions12106113fruitions
functions1437743functions
gumptions1443773gumptions
ignitions1045803ignitions
indictions1339313indictions
iodations1039113iodations
judicious1943753judicious
junctions1835943junctions
laudation1088133laudation_
lenitions939473lenitions
lunations9310723lunations
luxations1637273luxations
mediations13310983mediations
monitions11310883monitions
munition1038763munition_
mutations111211453mutations
nidations1039213nidations
nudities939683nuditi_es
nutations91411763nutations
nutritions1066513nutritions
partitions1248323partitions
perditions1348873perditions
petitions11511083petitions
positions11811503positions
punition1038373punition_
pupations1338123pupations
questions1845523questions
radiations11311923radiations
reeditions1147653reeditions
renditions1149183renditions
ructions102811683ru_ctions
sedations10311253sedations
sedition939333sedition_
seditious1046493seditious
subauditions1552583subauditions
suctions103012903su_ctions
sudation9310803sudation_
traditions1147193traditions
tuition738823tu_ition_
unctions1039733_unctions
venditions1445523venditions
volitions1288663volitions

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411097.25320493.7
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.73523101.6
 
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.