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

87 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
maximals1932522(None) 
maximal18347091maximal_
animals94111702_animals
mammals10389272ma_mmals
maxillas17227702maxillas
maxima17568632maxima__
maximalist2144372maximalist
maximally2344392maximally
maximins1944532maximins
maxims17399672maxim__s
maximums1842812maximums
minimals12327432minimals
animal85016253_animal_
animas84418723_anima_s
apicals1159923_apicals
axial124515193_axi_al_
axillas14278963_axillas
axils127217503_axi__ls
caimans113811783ca_imans
capitals12209443capitals
decimals1345863decimals
facials123310743faci_als
gavials1136603gavi_als
hamals114816823ha__mals
hammals14409223ha_mmals
labials9299873labi_als
lacrimals1342913lacrimals
laminals10339303laminals
lanitals837723lanitals
madrigals13856233madrigals
mafias113913573mafi_a_s
magians10310753magi_ans
magical1239783magical_
magmas115512503ma_gma_s
mahimahi1862803mahimahi
mahimahis1953163mahimahis
maills84215283ma_i_lls
mails76037783ma_i__ls
maimers113813043ma_imers
maims96321793ma_im__s
mamas95930773ma__ma_s
mammal95112753ma_mmal_
mammas94616403ma_mma_s
maniacs114313063mani_acs
manias84029033mani_a_s
manilas93915873manila_s
manillas102611163manillas
manuals9311213ma_nuals
marginals1246003marginals
marimbas1444363marimbas
marinas93519383marina_s
marital92314183marital_
marshals1337783marshals
matinal9312603matinal_
maxicoats2042863maxicoats
maxilla16248193maxi_lla
maxillae17256723maxillae
maxim165216003maxim___
maximalists2253103maximalists
maximin1835263maxim_in
maximise1944913maximise
maximises2044873maximises
maximite1955853maximite
maximites2045313maximites
maximize2844573maximize
maximizes2944403maximizes
maximum1743573maxim_um
maximumly2251123maximumly
maxis145721563maxi___s
maxixes1535253maxi_xes
maxwells2042653maxwells
mazumas2034623mazuma_s
medials103914733medi_als
medicals1349363medicals
menials94015683meni_als
meticals12310763meticals
minimal114010603minimal_
musicals1247093musicals
myxomas2153913myxoma_s
radials83614633radi_als
radicals112610153radicals
sahiwals1443643sahiwals
tamals84116633ta__mals
taxicabs1942223taxicabs
taximan1635783taxima_n
taxiways2142643taxiways
wadmals1335513wa_dmals

Search took 9 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.440406115.9
2DLD Change Limit146162877.54619369.5
3Display Results87870.0302900.0
 (SQL Overall)178691878.01622291.8
 
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.