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

111 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
atomised1127883(None) 
atomise93013821atomise_
atomiser10268151atomiser
atomises103514401atomises
atomized20279321atomized
agonised10248482agonised
anatomised13114902anatomised
atomies93918362atomi_es
atomisers11255452atomisers
atomism112610962atomis_m
atomisms12269572atomisms
atomist92915762atomis_t
atomists102610962atomists
atomize183111822atomize_
atomizer19298532atomizer
atomizes192711432atomizes
azotised1844442azotised
itemised11105162itemised
promised133010872promised
abolished1544273abolished
abscised1364133abscised
admired1135703a_dmired
admixed1833733a_dmixed
adonises92611433adonises
advised12136043a_dvised
agonise83112693agonise_
agonises92613163agonises
agonized19258993agonized
amortised1285813amortised
amused94412513a__mused
anatomise11117353anatomise_
anatomises1297363anatomises
anatomized2285863anatomized
anodized1946463anodized
anomie83215963anomi_e_
anomies93316993anomi_es
aphorised1546363aphorised
apomixes1934853apomixes
apprised1337713apprised
aroused84914343aro_used
astonied978983astoni_ed
astonished1443403astonished
atomic104115603atomi__c
atomical1248903atomical
atomics113110853atomi_cs
atomising1247993atomising
atomistic1347773atomistic
atomizers20265553atomizers
atoms76817563atom_s__
atoned75417543ato__ned
atonies75320953atoni_es
atopies92816433atopi_es
attained997353attained
attired8238913at_tired
attrited947373attrited
authorised1444513authorised
autolysed1384353autolysed
automated1248813automated
autopsied1244343autopsied
avoided1235553avo_ided
axised14438963a__xised
azotise1637073azotise_
azotises1737603azotises
azotized1745673azotized
bromized22215903bromized
canonised1256713canonised
customised1543253customised
demised113613683_demised
ebonised1136043ebonised
epitomised1553283epitomised
hoised105117433_ho_ised
idolised1045673idolised
iodised9329243_iodised
ionised82911493_ionised
itemise997453itemise_
itemises1087693itemises
itemized20105343itemized
lionised946603lionised
maximised2143573maximised
motorised1247263motorised
noised75416233_no_ised
optimised1444313optimised
ozonised1853893ozonised
pantomimed1742943pantomimed
patronised1395033patronised
poised94918473_po_ised
premised133013193premised
promise113415843promise_
promisee122711333promisee
promiser122510673promiser
promises122916763promises
remised103516843_remised
satirised1046553satirised
stimied10310623stimi_ed
stomped124110533stom_ped
stonished1345593stonished
storied8515163stori_ed
stylised12215893stylised
stymied1335663stymi_ed
surmised1136863surmised
tamises92715973_tamises
toiled74420323_to_iled
toited74016753_to_ited
tombed113812133_tom_bed
tommed113310143_tom_med
tossed74215223_to_ssed
toused74122013_to_used
utilised956733utilised
valorised13247103valorised
vaporised15216953vaporised
vomited1337253_vomited

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.483369960.7
2DLD Change Limit1461621117.05020732.2
3Display Results1111110.0303700.0
 (SQL Overall)1786911117.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.