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

165 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
metis7502590(None) 
metes74736211metes
meths105320231meths
mitis75425991mitis
yetis85418391yetis
aegis6316782aegis
antis55033312antis
betas75528762betas
beths105519222beths
betise85616272betise
bets67051442bet_s
cedis84317082cedis
cetes75731102cetes
cutis77723752cutis
defis96717502defis
delis64928542delis
egis56520652_egis
emesis84712622emesis
emetic10614452emetic
emetics11610722emetics
emetin8613462emetin
emetins9812642emetins
emits75421472emits
etas46432272_etas
eths76619522_eths
etic66123952_etic
etuis54013132_etuis
fetas85624402fetas
fetes85630142fetes
fetid93715982fetid
fetish12310372fetish
fets75345942fet_s
fetus85816542fetus
getas65421482getas
gets55442482get_s
heths116317782heths
hets75547202het_s
intis55121642intis
jetes124922842jetes
jets115834102jet_s
kepis115313362kepis
leis45739602le_is
lenis56326862lenis
lets47147942let_s
levis85818552levis
lewis85315842lewis
lexis125916032lexis
mantis83926032mantis
mates75251362mates
maths105624022maths
matin75132852matin
matins84527782matins
mats65460282mat_s
matts76829182matts
mavis105622722mavis
maxis145721562maxis
meads85425322meads
meals75933372meals
means75831222means
meats75034052meats
meatus85112922meatus
media84721712media
medias93620782medias
medic104619652medic
medics114115352medics
medii84513492medii
medius93613282medius
meds75735362me_ds
meeds84920272meeds
meets74224612meets
megs75530632me_gs
melds84822382melds
melic94722332melic
mells75031332mells
mels65941532me_ls
melts74930102melts
memes94927702memes
memos95719112memos
mems85931502me_ms
mends84927692mends
menus75822842menus
meous76120062meous
meows104612682meows
mercs96020452mercs
meres75143572meres
merit7339182merit
merits8320872merits
merks114722402merks
merls77423902merls
mesas76823202mesas
mesic93617862mesic
mess65932432me_ss
met56072432met__
meta65932412met_a
metal75427382metal
metals84520882metals
mete64438132met_e
meted85424432meted
meter75130322meter
meters85625832meters
meth95827842met_h
metier83517692metier
metiers93312842metiers
meting94320592meting
metisse936502metisse
metol75917812metol
metols84115772metols
metre74821302metre
metres85121562metres
metric10314672metric
metrics11312362metrics
metrist9317062metrist
metro74718802metro
metros84217802metros
mewls105813232mewls
mews96629332me_ws
mezes167719262mezes
midis85923412midis
minis75432992minis
mis58162622m__is
mites75141802mites
mitts75523752mitts
motes75944002motes
moths106021552moths
motif10519672motif
motifs1139672motifs
mots66853162mot_s
motts76527002motts
muftis1158052muftis
munis75022002munis
mutes75033782mutes
mutism103211462mutism
muts64839982mut_s
mutts75120252mutts
myths135911602myths
nets45941532net_s
netts55320722netts
penis75129322penis
peris75537072peris
petit74332652petit
pets66248332pet_s
reis45343232re_is
retia55326112retia
retie55735302retie
reties65436192reties
rets45352562ret_s
rotis56327052rotis
satis55633672satis
seis45542392se_is
semis74623532semis
sets45549502set_s
setts55124322setts
testis64916712testis
teths85418512teths
tetris62816292tetris
tets45847452tet_s
tis37056642__tis
titis56023812titis
tmesis8529792tmesis
vets76835092vet_s
wets75940292wet_s
yeti75823212yeti_
yetts86715132yetts
zetas145018162zetas
zitis145815582zitis

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.0931921408.6
2DLD Change Limit538001651.94027732.0
3Display Results1651650.0463587.0
 (SQL Overall)1786911652.07985950.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.