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

75 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
matilda104498(None) 
matildas1145021matildas
latilla737952latilla
manila84518302manil_a
manilla93012472manilla
mantilla1048162mantilla
maxilla16248192maxilla
atilt54828473_atil_t
axilla13289573_axilla
barilla9310323barilla
cabildo1254723cabildo
catalpa1136503catalpa
latillas847363latillas
latina65621143lati_na
macula103013673macul_a
mafia104418033mafi__a
magilp1137613magil_p
magilps1234083magilps
maid75537663ma_i_d_
maids86327143ma_i_ds
mail65543453ma_il__
mailbag1243923ma_ilbag
maile75232223ma_il_e
mailed95326753ma_iled
mailer84724183ma_iler
mailes84329113ma_iles
maill74420793ma_il_l
maills84215283ma_ills
mailman1137733ma_ilman
mails76037783ma_il_s
mammilla1143933mammilla
mania75634153mani__a
manilas93915873manilas
manillas102611163manillas
manille92613273manille
manioca11358943manioca
mantid93820383manti_d_
mantids103113623manti_ds
mantillas1147043mantillas
mantissa1044573mantissa
maquila1844703maquil_a
maria75032883mari__a
marimba1354983marimba
marina84623413mari_na
masala8311813masal_a
mated85537783mat_ed_
matelot9411573matelot
matier84321523mati_er
matiest92522453matiest
matin75132853mati__n
matinal9312603matinal
matinee92415613matinee
mating94832913mati_ng
matings104516213matings
matins84527783mati_ns
matted94521413matted_
matza16311813mat__za
maxillae17256723maxillae
maxillas17227703maxillas
maxima17568633maxi_ma
mazily20610393mazil_y
meatily12311093meatil_y
megilla1036273megilla
mild75330853m__ild_
milds86422053m__ilds
milia72719573m__ilia
milpa92111403m__ilpa
motile83818343motil_e
motiles93317433motiles
papilla11127913papilla
patella938953patella
patina86022193pati_na
ramtilla1054733ramtilla
tilde65017343__tilde
vanilla10238743vanilla

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.403443402.0
2DLD Change Limit134027757.26618445.8
3Display Results75750.0332272.7
 (SQL Overall)178691757.70223200.6
 
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.