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

138 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
agatize173983(None) 
agatized1947071agatized
agatizes1838861agatizes
agate66525152agat__e
agaze156113662aga__ze
agenize172910152agenize
agnize16329562ag_nize
agonize172911402agonize
amative12311732amative
apatite9312962apatite
arabize1849342arabize
azotize1537082azotize
paganize2048632paganize
abate76627843abat__e
abating10413973abating
abatis84317933abati_s
abatises10311013abatises
abaxile1644083abaxile
ablative1348243ablative
acarine9316003acarine
active11313743a_ctive
adaptive1445133adaptive
again65218123aga_i_n
agamete1037403agamete
agamic113110563agami_c
agamid103710693agami_d
agamids11317013agamids
agapae9388043aga_pae
agape85614843aga__pe
agaric93513633agari_c
agarics10319943agarics
agarose838673agarose
agates76121343agat_es
agatizing2087473agatizing
agatoid948623agatoid
agave95314033aga__ve
agenized19257733agenized
agenizes18269743agenizes
agentive1248043agentive
aggie73415013ag_gi_e
agile65122263ag__ile
agitate8312063agitate
agitative1346873agitative
agnate73314883agnat__e
agnatic10310973agnati_c
agnation9311723agnation
agnized18247223ag_nized
agnizes17328843ag_nizes
agonise83112693agonise
agonized19258993agonized
agonizes182610583agonizes
airtime948063airtime
alanine7316863alanine
alate55340323alat__e
alation72920553alation
alkalize21177633alkalize
amaze166016603ama__ze
amortize1987743amortize
analyze19167013analyze
anatase738943anatase
anatomize2087113anatomize
anodize1738683anodize
anytime1246043anytime
apatites10311293apatites
apprize2038183apprize
arabized2047173arabized
arabizes1969103arabizes
aromatize20410303aromatize
assize1538633a_ssize
astatine8313533astatine
atomize183111823atomize
attire62412383a_ttire
auntie64317703aunti_e
avarice1238033avarice
avianize2045723avianize
azotise1637073azotise
azotized1745673azotized
azotizes1636853azotizes
baize164717393_ba_ize
banalize191010933banalize
baptize2036983baptize
braize174113113bra_ize
canalize19914493canalize
cavatine13310323cavatine
dative10311813_dative
digitize1947023digitize
dogmatize2265763dogmatize
dramatize2147893dramatize
dualize1759763dualize
egalite8311563egalite
elative10312453elative
ergative1238973ergative
erotize16311663erotize
faradize21237823faradize
gamine94620153_gamine
gate55746573_gat__e
gating84826953_gating
gauze155712973_ga_uze
gaze145032413_ga__ze
gratine84719193gratine
hepatize2248233hepatize
isatine7311763isatine
japanize2645283japanize
kyanize23265343kyanize
laxative1845093laxative
legalize1839103legalize
legatine91311403legatine
ligative1258803ligative
magazine2046553magazine
magnetize21519873magnetize
maize164618563_ma_ize
nasalize1748183nasalize
native9613013_native
negative1239083negative
organize1849093organize
paganise1139663paganise
paganized2247163paganized
paganizer2145763paganizer
paganizes2148663paganizes
palatine10316063palatine
patine85328123_patine
pectize20259913pectize
peptize20279483peptize
poetize18310773poetize
quantize2645963quantize
ragtime1036163rag_time
ratine65131823_ratine
ratite65022423_ratite
realize162717083realize
sanative11310473sanative
sanitize171410083sanitize
satire63218003_satire
saxatile1544953saxatile
statice92614033statice
stative102612933stative
teatime9310083teatime
unitize16310033unitize
zaratite1747793zaratite

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271386.76619808.9
3Display Results1381380.0632190.5
 (SQL Overall)1786911387.23524698.1
 
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.