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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
marten8451826(None) 
marted94425211marted
martens93714951martens
martin84122521martin
smarten9348861smarten
arpen74418042_arpen
artel56122742_artel
barmen105418532barmen
barren85317612barren
bartend1038752bartend
barter85525372barter
batten85217122batten
careen84119492careen
carmen104019342carmen
carte75940422carte_
carted98631442carted
cartel85022532cartel
carter84932272carter
cartes86239472cartes
carton84522662carton
carven114716662carven
darken114013442darken
darted84620922darted
darter75320362darter
earthen1039252earthen
eaten55323052ea_ten
farted105121782farted
fasten95114892fasten
fatten94314902fatten
garden84215082garden
garter74420512garter
hapten115312982hapten
harden105718532harden
harken135116342harken
hasten95718562hasten
hearten102411752hearten
laten54328342la_ten
latten65018202latten
madden103912522madden
madmen113511742madmen
maiden93512282maiden
malted94819852malted
mantel84317972mantel
mantes84430782mantes
marcel103714852marcel
marchen143312072marchen
mare64759322mar_e_
mares76457632mar_es
marge85328332marge_
margent10316692margent
marges94525712marges
margin94016842margin
marine84230402marine
marked133921622marked
marker124420392marker
market123226042market
marled95523162marled
marlin84220902marlin
maroon83118202maroon
marred95421042marred
marrer83716672marrer
marron83717542marron
marse76231152marse_
marses84827112marses
mart66865972mart__
martian93514682martian
marting103325012marting
martini93613872martini
martins93322062martins
martlet93419152martlet
marts77442232mart_s
martyr1135692martyr
marvel113712002marvel
masted94025802masted
master84831342master
mate65154212ma_te_
mated85537782ma_ted
mater74438862ma_ter
mates75251362ma_tes
matey107022662ma_tey
matin75132852ma_tin
matres84522232matres
matron83918312matron
matte75626842matte_
matted94521412matted
matter84325342matter
mattes85624532mattes
mattin84416632mattin
maven104816892ma_ven
mermen10813812mermen
mitten83914092mitten
molten83311812molten
moreen8313342moreen
morgen9312202morgen
oaten55222402oa_ten
partan83820562partan
parted94228682parted
parton84720992parton
paten74827342pa_ten
patten84418192patten
ratten64217382ratten
sarsen6314232sarsen
smarted105012612smarted
smartens10286662smartens
smarter94113132smarter
tartan64217512tartan
tarted74923372tarted
tarter64023562tarter
tauten64311892tauten
torten65314352torten
warden104515512warden
warren95012852warren
warted104223232warted

Search took 3 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 Filter178691825510.1261418182.5
2DLD Change Limit825511132.50033020.4
3Display Results1131130.0462456.5
 (SQL Overall)1786911132.67266875.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.