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

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

82 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
maund8551544(None) 
maud75325391mau_d
maun65727201maun_
maunds9519651maunds
maundy12506781maundy
mound83918311mound
amend85717752amend
and47244162_a_nd
auld54125362_auld
aunt46553652_aunt
band76740902ba_nd
baud74928422bau_d
bound84819582bound
bund75530662_bund
cauld85318442cauld
daunt65929082daunt
fauld95214492fauld
faun76226622faun_
fauna84816512fauna
fauns84516752fauns
found94917842found
fund85624982_fund
gaud67025432gau_d
gaun56427712gaun_
gaunt65430402gaunt
hand86833702ha_nd
haunt85229132haunt
hound95016482hound
jaunt125025272jaunt
land56337302la_nd
laud56527722lau_d
maced108528692maced
mad68958702ma__d
maenad939412maenad
maid75537652ma_id
main65345512main_
mains75635102mains
man57465852ma_n_
mana65341942ma_na
mane65052012ma_ne
maned86634092maned
manna75522532manna
manned94418642manned
mano66536792ma_no
mans66354532ma_ns
manus75924922manus
many95731842ma_ny
mated85537782mated
mauds85519272mauds
maul64830712mau_l
mauled94817822mauled
mauls76524952mauls
maunder10328682maunder
maut65448442mau_t
mauts75927192mauts
mauve104013272mauve
mawed115824742mawed
mawn94424132mawn_
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
mend75334022m_end
mind75434372m_ind
mould86015752mould
mounds93915132mounds
mount74128062mount
mud67336862m_u_d
mun56143852m_un_
muni65824402m_uni
muns65535912m_uns
pound84417862pound
rand55839562ra_nd
round64318432round
sand55338462sa_nd
sauna54117552sauna
sound64420022sound
taunt55532282taunt
vaunt85925312vaunt
wand85833872wa_nd
wound94414212wound
yaud87020082yau_d
yauld95511182yauld

Search took 4 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 Filter178691538000.1701051123.5
2DLD Change Limit53800823.61014903.0
3Display Results82820.0461782.6
 (SQL Overall)178691823.82646704.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.