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

190 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
matey10702266(None) 
mamey125418831mamey
mate65154211mate_
mated85537781mated
mater74438861mater
mates75251361mates
mateys115610941mateys
motey105922951motey
ate37059242_ate_
ates45047922_ates
bate66552422bate_
bated85935532bated
bates75846342bates
batty105422242batty
cagey115917822cagey
cakey145517272cakey
cate66254592cate_
cater74840702cater
cates75951872cates
catty104520412catty
cutey105819792cutey
date56443322date_
dated75530992dated
dater65332312dater
dates65639152dates
eaten55323052eaten
eater54639842eater
eatery95316352eatery
fakey155515422fakey
fate75444282fate_
fated95632132fated
fates85139232fates
fatly115716802fatly
fatty115117412fatty
gamey115320552gamey
gate55746572gate_
gated75329772gated
gater64533642gater
gates65939502gates
hate78450172hate_
hated95734022hated
hater85034752hater
hates86742572hates
hayey144812532hayey
lacey105820912lacey
late47560482late_
lated65240672lated
lately93413842lately
laten54328342laten
later54843922later
latex124717112latex
lathy115215062lathy
mabe85733352mabe_
mabes96331532mabes
mace87345782mace_
maced108528692maced
macer912126942macer
maces97139962maces
made75440232made_
madly115218132madly
mae57659102ma_e_
maes66948392ma_es
mage75739122mage_
mages85036022mages
maguey1236832maguey
make105537882make_
maker114127812maker
makes115336852makes
male66052292male_
males75049792males
malmy124816342malmy
malted94819852malted
malty106721702malty
mameys13449522mameys
mammey124310892mammey
mammy115215162mammy
mane65052012mane_
maned86634092maned
manes76648952manes
mangey123614522mangey
mangy115021232mangy
manly105022942manly
mantel84317972mantel
mantes84430782mantes
many95731842ma_ny
mare64759322mare_
mares76457632mares
marly106925612marly
marry104821692marry
marted94425212marted
marten84518262marten
marvy135014032marvy
maser75029972maser
mashy136016502mashy
massy104518962massy
masted94025802masted
master84831342master
mastery124214322mastery
mat58083932mat__
match125621102match
maters85032382maters
math95437442mat_h
maths105624022maths
matier84321522matier
matin75132852matin
matres84522232matres
mats65460282mat_s
matt65752652mat_t
matte75626842matte
matted94521412matted
matter84325342matter
mattery123810712mattery
mattes85624532mattes
matts76829182matts
matza16311812matza
matzo16312892matzo
maven104816892maven
mawed115824742mawed
maxed155821192maxed
maxes145629532maxes
may88757622ma__y
mayed115522402mayed
maze155434972maze_
mazed175523872mazed
mazer165722422mazer
mazes165632172mazes
mazy186419692ma_zy
meated94222402meated
meaty107021312meat_y
mete64438132mete_
meted85424432meted
meter75130322meter
metes74736212metes
mite66249412mite_
miter75734792miter
mites75141802mites
mity95528212mit_y
moated94819002moated
money104826842money
mopey124821822mopey
mosey105922872mosey
mote67048082mote_
motel76623242motel
motes75944002motes
motet75641192motet
mothy136214552mothy
motley1139382motley
muley104819282muley
mute65136872mute_
muted85023382muted
mutely113811652mutely
muter74525542muter
mutes75033782mutes
mythy16568672mythy
nates55238332nates
natty85719142natty
oaten55222402oaten
oater55433732oater
pacey126720282pacey
pate65350462pate_
pated85237842pated
paten74827342paten
pater74740722pater
pates76047892pates
patly105020582patly
patsy105717202patsy
patty104723612patty
paty95234562pat_y
rate45458762rate_
rated65441382rated
ratel54224882ratel
rater54943282rater
rates55352012rates
ratty84819592ratty
satay84718462satay
sate45556102sate_
sated66238532sated
satem76021452satem
sates54949322sates
slatey95417062slatey
stey76224412_stey
tate44748602tate_
tater54138612tater
tates55444982tates
tatty84720182tatty
waney115120322waney
water84733312water
watery123914492watery
wavey145115542wavey
yawey14458272yawey

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 Filter178691538000.1101624463.6
2DLD Change Limit538001902.06326078.5
3Display Results1901900.0603166.7
 (SQL Overall)1786911902.23380022.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.