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

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

207 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
mythier1512518(None) 
mothier121910211mothier
lathier10310832lathier
luthier1038232luthier
matier84321522mat_ier
meshier123410852meshier
metier83517692met_ier
mither114218562mith_er
mitier83620662mit_ier
mother113718642moth_er
motlier92010582motlier
mouthier13208172mouthier
mushier123813582mushier
mynheer1542282mynheer
mythic1637272mythi_c
mythiest1636032mythiest
pithier123010292pithier
withier132910492withier
achier113914263_achier
aether94213673aeth_er
anther93715063anth_er
antsier7410773antsier
artier63419733art_ier
artsier768943artsier
ashier94714833_ashier
bather115322513bath_er
battier93515713battier
bitchier15307733bitchier
bitsier9379073bitsier
bittier94211663bittier
botchier15287143botchier
bother115218063both_er
bothies12414783bothies
bushier123712813bushier
cahier113615773_cahier
cashier123713323cashier
catchier15329863catchier
cattier93317073cattier
cither114616683cith_er
clothier1335363clothier
cottier93814173cottier
couthier13218903couthier
cushier123610833cushier
cypher16306593cyph_er
dashier114311183dashier
dishier113613403dishier
dither104417683dith_er
ditsier83010293ditsier
ditzier17307963ditzier
dotier73917033dot_ier
dottier83910923dottier
earthier1137443earthier
either94517423eith_er
emptier1187603empt_ier
ether84518773_eth_er
father125116713fath_er
fattier103513463fattier
filthier1434073filthier
fishier13359853fishier
flytier13356503flyt_ier
frothier1435953frothier
gather104115853gath_er
gushier113110073gushier
gutsier8389823gutsier
guttier83911103guttier
heathier1438343heathier
hither124417253hith_er
itchier12247673itchier
ither84617603_ith_er
jettier14358693jettier
kythe15509673kyth_e_
kythed17407313kyth_ed
kythes16499133kyth_es
kything18285523kything
lather95124353lath_er
lither94520953lith_er
luthiers1135163luthiers
malmier113611953malmier
maltier93015483maltier
mangier104114063mangier
manlier92414023manlier
marlier92614773marlier
marrier93817523marrier
marshier1337593marshier
masher114123203mash_er
mashie11315933mashie_
mashies12318253mashies
massier93615223massier
matcher143214283matcher
mater74438863mat__er
matter84325343mat_ter
maturer938973maturer
mazier175013063m_azier
mealier93015903mealier
meatier93214613meatier
menhir1136783menhi_r
merrier92612303merrier
messier93412923messier
metamer1139613metamer
meter75130323met__er
metiers93312843met_iers
miffier1537023miffier
mightier1436383mightier
milkier133411163milkier
millier93716703millier
miltier93214963miltier
mincier113512463mincier
mingier103815283mingier
mintier93615993mintier
mirier83918353m_irier
mirkier13319053mirkier
mistier93418713mistier
miter75734793mit__er
miterer92511333miterer
mithers123516733mith_ers
moldier103110033moldier
moodier103212203moodier
moonier93714103moonier
moorier93113073moorier
mopier103914783m_opier
mosher114719793mosh_er
mossier94413813mossier
mothers123717623moth_ers
mothery153710513moth_ery
mothiest13311033mothiest
mottler94410343mottler
mousier93712463mousier
mouther123812813mouth_er
muckier153411473muckier
muddier114110013muddier
muggier11288943muggier
murkier133110263murkier
murther1237953murth_er
musher113820573mush_er
muskier134312723muskier
mussier93314353mussier
mustier94017953mustier
muter74525543mut__er
mutter84418883mut_ter
muzzier17326553muzzier
mynheers1642113mynheers
myopies14309713myopies
mystifier1744363mystifier
myth126715433myth___
mythical1845023mythical
mythicizer29152973mythicizer
mythmaker2352323mythmaker
mythoi14417123myth_oi
mythos14398463myth_os
myths135911603myth__s
mythy16568673myth__y
nattier73614623nattier
nether94014163neth_er
nettier74211813nettier
nittier73512243nittier
nother93815963noth_er
nutsier7329253nutsier
nuttier73112023nuttier
other84219103_oth_er
outlier72216143outlier
patchier15319663patchier
pettier94213613pettier
pitchier15368273pitchier
pitier84019823pit_ier
pother113818853poth_er
pottier93516493pottier
pushier123611093pushier
puttier93314503puttier
rather94319733rath_er
rattier74015593rattier
ritzier16297203ritzier
rushier103411973rushier
ruttier73412283ruttier
shier85428943__shier
smithies1337913smithies
smother123510203smoth_er
smutchier1643503smutchier
smuttier1035213smuttier
sypher14317083syph_er
tattier74216243tattier
techier1269243techier
tetchier1336453tetchier
tether93716103teth_er
their85512153__their
thief114516293__thief
thir76420543__thi_r
tier44936143__t_ier
tither94920283tith_er
toothier1136423toothier
tother94117143toth_er
trier54328533__trier
twier84713293__twier
typier1137333ty_pier
tythe115210453tyth_e_
tythed13457503tyth_ed
tythes12419703tyth_es
tything14316573tything
washier133611153washier
wether123315393weth_er
witchier16307883witchier
wither124321353with_er
withies133913543withies
wittier103910823wittier
worthier1436713worthier
wrathier1435903wrathier
wuther124511613wuth_er
zither183813083zith_er

Search took 9 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.1401276364.3
2DLD Change Limit1340272078.11016526.1
3Display Results2072070.0802587.5
 (SQL Overall)1786912078.33021451.5
 
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.