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

142 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
maximal1834709(None) 
maxima17568631maxima_
maximals19325221maximals
animal85016252_animal
axial124515192_axi_al
magical1239782magical
mammal95112752ma_mmal
marital92314182marital
matinal9312602matinal
maxilla16248192maxilla
maxim165216002maxim__
maximally2344392maximally
maximin1835262maximin
maxims17399672maxim_s
maximum1743572maximum
minimal114010602minimal
taximan1635782taximan
abaxial1646183abaxi_al
adaxial1545323adaxi_al
anima74620073_anima_
animals94111703_animals
animas84418723_animas
apical10913903_apical
axal116520493_ax__al
axeman1538103_axeman
axil116424453_axi__l
axilla13289573_axilla
axman144813183_ax_man
axonal1347653_axonal
basinal9310033basinal
biaxial1645363biaxi_al
caiman103615663ca_iman
capital112311523capital
carinal94318233carinal
coaxial16157003coaxi_al
datival1135583datival
decimal1238083decimal
facial113615633faci_al
gavial10310083gavi_al
haemal113811643ha_emal
hamal104623113ha__mal
hammal134512063ha_mmal
imaginal1144903imaginal
intimal9109943intimal
labial84714343labi_al
lacrimal1244443lacrimal
laical8312323la_ical
laminal94113633laminal
lanital7310913lanital
lexical1637363lexical
madman113712383ma_dman
madrigal121627253madrigal
mafia104418033mafi_a_
mafias113913573mafi_as
magian9312833magi_an
magma104513573ma_gma_
magmas115512503ma_gmas
mahimahi1862803mahimahi
mail65543453ma_i__l
maill74420793ma_i_ll
mailman1137733mailman
maim85831493ma_im__
maimed114812663ma_imed
maimer104514593ma_imer
maims96321793ma_im_s
mama86231593ma__ma_
mamas95930773ma__mas
mamma86317913ma_mma_
mammae94613213ma_mmae
mammals10389273ma_mmals
mammas94616403ma_mmas
mania75634153mani_a_
maniac103917973mani_ac
maniacal1246723maniacal
manias84029033mani_as
manila84518303manila_
manilas93915873manilas
manilla93012473manilla
manual8313463ma_nual
marginal1137603marginal
maria75032883mari_a_
marimba1354983marimba
marimbas1444363marimbas
marina84623413marina_
marinas93519383marinas
marshal1238973marshal
martial92415413martial
maxi137023563maxi___
maxicoat1945033maxicoat
maxillae17256723maxillae
maxillas17227703maxillas
maximalist2144373maximalist
maximins1944533maximins
maximise1944913maximise
maximite1955853maximite
maximize2844573maximize
maximumly2251123maximumly
maximums1842813maximums
maxing164817073maxi_ng
maxis145721563maxi__s
maxixe1435223maxi_xe
maxixes1535253maxixes
maxwell1942513maxwell
mayoral1237693mayoral
mazuma1935603mazuma_
mazumas2034623mazumas
medial93819863medi_al
medical12312513medical
menial84223033meni_al
mesial84818083mesi_al
metical11315363metical
miasmal1176743miasmal
mimical1339233mimical
minima105512653minima_
minimals12327433minimals
minimax18376013minimax
monaxial1745953monaxi_al
musical1139553musical
myxoma2043943myxoma_
myxomas2153913myxomas
nadiral836343nadiral
narial6317953nari_al
nasial6413283nasi_al
optimal1145783optimal
paginal10269493paginal
primal104014623_primal
proximal1945183proximal
racial83419243raci_al
radial74020393radi_al
radical103312793radical
ramal74622243ra__mal
sahiwal1344443sahiwal
submaximal2351963submaximal
tamal73522623ta__mal
taxicab1843413taxicab
taximen1644923taximen
taxiway2043463taxiway
taxman15328613tax_man
toxical1637643toxical
vaginal11288403vaginal
vatical1239983vatical
wadmal1237283wa_dmal

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271426.04622167.9
3Display Results1421420.0463087.0
 (SQL Overall)1786911426.49827499.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.