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

61 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
madeiras114476(None) 
madeira1045101madeira_
madras94316422mad__ras
pareiras1038182pareiras
admiral1046363_admiral
admirals1144353_admirals
admires1038663_admires
cadenzas2053743cadenzas
calderas1147863calde_ras
cameras11313343came_ras
capoeiras1343183capoeiras
codeias103911213codei_as
codeinas11338013codeinas
fadeins1168503fadei_ns
faders105117463fade_r_s
jadeites1645823jadeites
laders74927763lade_r_s
macers105321273mace_r_s
madders113513213madder_s
maderize2049073maderize
maderizes2148943maderizes
madonnas1143843madonnas
madrasa10387883mad__rasa
madrasas11317763madrasas
madres93718183mad__res
madrigal121627253madrigal
madrigals13856233madrigals
madronas11288493madronas
maduros1036283mad_uros
madworts1456173madworts
maffias15327283maffi_as
mafias113913573ma_fi_as
maftirs1236043maftir_s
magentas1137923magentas
mairs76228293ma__ir_s
makers123921733make_r_s
malarias10313753malarias
manias84029033ma_ni_as
manilas93915873ma_nilas
mantras93815863ma_ntras
maquilas1944033maquilas
maras75443283ma___ras
marinas93519373ma_rinas
mascaras1237693mascaras
masers84623453mase_r_s
material10314093material
materials11510783materials
maters85032383mate_r_s
maybirds1643323maybirds
mazers173917093maze_r_s
mbiras1077143m__biras
medias93620783med_i_as
medinas103411463med_inas
midairs1037193midair_s
moderns1037963mode_rns
mudras94212253mud__ras
nadiral836343nad_iral
nadirs7109003nad_ir_s
nairas6312773na__iras
pareira937533pareira_
waders109120643wade_r_s

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162617.17320376.7
3Display Results61610.0302033.3
 (SQL Overall)178691617.35924282.0
 
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.