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 “azotised” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

64 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
azotised184444(None) 
azotise1637071azotise_
azotises1737601azotises
azotized1745671azotized
agonised10248482agonised
amortised1285812amortised
atomised11278832atomised
azoted16388592azot__ed
azotize1537082azotize_
azotizes1636852azotizes
ozonised1853892ozonised
abatises10311013abatises
abolished1544273abolished
abscised1364133abscised
adonises92611433adonises
advised12136043a_dvised
agatized1947073agatized
agonise83112693agonise_
agonises92613163agonises
agonized19258993agonized
amortise10428513amortise_
amortises1178823amortises
amortized2185933amortized
anodized1946463anodized
antired82316193a_ntired
antisex1439693a_ntisex
aphorised1546363aphorised
apprised1337713apprised
aroused84914343aro_used
atomise93013823atomise_
atomiser10268153atomiser
atomises103514403atomises
atomized20279323atomized
attired8238913a_ttired
avoided1235553avo_ided
axised14438963a__xised
azote144416343azot__e_
azotes154312223azot__es
azoths18366203azoths__
azotic172711633azoti__c
azotising1945293azotising
baptised1335263baptised
canonised1256713canonised
diazotized2052673diazotized
ebonised1136043ebonised
erotized1838553erotized
hoised105117433_ho_ised
idolised1045673idolised
iodised9329243_iodised
ionised82911493_ionised
lionised946603lionised
mortised1178743mortised
motived13357763_motived
noised75416233_no_ised
noticed1037863_noticed
ozonise1646443ozonise_
ozonises1776373ozonises
ozonized1745113ozonized
poetised1138523poetised
poised94918473_po_ised
promised133010873promised
sanitised10147353sanitised
valorised13247103valorised
vaporised15216953vaporised

Search took 7 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.1531167915.0
2DLD Change Limit146162646.45622639.7
3Display Results64640.0134923.1
 (SQL Overall)178691646.62226984.4
 
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.