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

100 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
fault85428311fault
gault65128471gault
malt66254801ma_lt
maul64830711maul_
mauls76524951mauls
maut65448441mau_t
moult74728721moult
sault55834961sault
vault85823761vault
adult63520652adult
alt36467962_a_lt
amulet8419572amulet
auld54125362_auld
aunt46553652_aunt
baulk114914332baulk
caul65630002caul_
cauld85318442cauld
caulk115315452caulk
cauls75727772cauls
cult66541152_cult
daunt65929082daunt
daut56443562dau_t
exult122814122exult
fauld95214492fauld
faults94513552faults
faulty12429362faulty
gaults74112772gaults
gaunt65430402gaunt
halt76056302ha_lt
haul75530452haul_
haulm104415412haulm
hauls86123732hauls
haunt85229132haunt
haut75949732hau_t
jaunt125025272jaunt
macle96127002macle
macula103013672macula
macule104115272macule
madly115218132madly
magot8326392magot
mail65543432mail_
maile75232212maile
maill74420782maill
mails76037772mails
maist75535672maist
male66052292ma_le
mall64639362ma_ll
mallet84433052mallet
malls76233432malls
malm85129972ma_lm
malts76331752ma_lts
malty106721702ma_lty
manat76039982manat
manly105022942manly
maple95521142maple
marl66341612marl_
marls75535162marls
marly106925612marly
mart66865972ma_rt
mast65959952ma_st
mat58083932ma__t
matt65752652ma_tt
maud75325392mau_d
mauds85519272mauds
mauled94817822mauled
mauler84416712mauler
maumet103518882maumet
maun65727202mau_n
maund85515442maund
mauts75927192mauts
mauve104013272mauve
mayst106622672mayst
melt65752892m_elt
miaul71612122miaul_
miauls8178712miauls
milt65455802m_ilt
molt66356162m_olt
mould86015752mould
moults84713702moults
mount74128062mount
mulct93820082m_ulct
mule65236972m_ule
mull65128802m_ull
must65145442m_ust
mut58357182m_u_t
mutt65739402m_utt
poult76928872poult
salt45758522sa_lt
saul45836522saul_
sauls55128122sauls
saults65816172saults
smalt74729332sma_lt
taunt55532282taunt
taut47048962tau_t
vaults94511672vaults
vaulty12388442vaulty
vaunt85925312vaunt
waul76927312waul_
wauls86120552wauls
yauld95511182yauld

Search took 2 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.0931921408.6
2DLD Change Limit538001001.40638264.6
3Display Results1001000.0303333.3
 (SQL Overall)1786911001.529116867.9
 
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.