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

105 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
mashy13601650(None) 
ashy107717351_ashy
dashy125612381dashy
marshy14558331marshy
mash96039391mash_
massy104518961massy
meshy135612781meshy
mushy135316631mushy
washy145911841washy
achy126316092_achy
ash67944602_ash_
bash915240162bash_
bassy1012917102bassy
brashy145210592brashy
bushy135416682bushy
cash96636282cash_
casky144512682casky
cushy134412322cushy
dash87031632dash_
dashi95013112dashi
dishy125712352dishy
easy76224492eas_y
fash107232292fash_
fishy146011662fishy
flashy15498172flashy
gash86833022gash_
gassy95514022gassy
gushy125213122gushy
hash106936502hash_
hasty115718762hasty
kasha124710722kasha
lash76539652lash_
lathy115215062lathy
mach116134472mach_
mache125925302mache
macho126120152macho
machs125722562machs
madly115218132madly
malmy124816342malmy
malty106721702malty
mamey125418832mamey
mammy115215162mammy
mangy115021232mangy
manly105022942manly
many95731842ma_ny
marly106925612marly
marry104821692marry
marsh105320852marsh_
marvy135014032marvy
mas58175812mas__
masa65034712mas_a
masas75630412masas
maser75029972maser
mashed125325042mashed
masher114123202masher
mashes115030002mashes
mashie11315932mashie
mask105227352mas_k
masks115320532masks
mason74820182mason
mass66044932mas_s
massa75518922massa
masse75125292masse
mast65959952mas_t
masts77035762masts
matey107022662matey
math95437442math_
maths105624022maths
may88757622ma__y
mazy186419692ma_zy
measly113610442measly
mesh96823002mesh_
messy104913832messy
missy105617562missy
misty106120452misty
mosey105922872mosey
mosh95227602mosh_
mossy105217062mossy
mothy136214552mothy
mush94929122mush_
musky144715292musky
mussy104117642mussy
musty105620952musty
mythy16568672mythy
nasty85717282nasty
pash95638132pash_
pasha105417182pasha
pasty105725052pasty
plashy14448872plashy
pushy134614352pushy
rash76039932rash_
rashly123410212rashly
raspy106511702raspy
rushy115414812rushy
sash77235302sash_
sashay1238362sashay
sassy85813812sassy
shy96728192__shy
smash104814432smash_
tasty84820312tasty
trashy12509052trashy
tushy114212992tushy
vasty116215922vasty
wash106033812wash_
waspy135410992waspy

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.0762351197.4
2DLD Change Limit538001051.82629463.3
3Display Results1051050.0333181.8
 (SQL Overall)1786911051.93592346.8
 
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.