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

130 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
mewls10581323(None) 
meals75933371meals
mells75031331mells
mels65941531me_ls
merls77423901merls
mewl95618321mewl_
mews96629331mew_s
awls75926092_awls
bawls105719322bawls
bells76432162bells
bels66142492be_ls
bowls106121432bowls
ceils75019402ceils
cells75428062cells
cels65534972ce_ls
cowls106922212cowls
deals65435342deals
deils65722862deils
dells66630942dells
dels56745472de_ls
dews86230602dew_s
eels46536742_eels
ells46431352_ells
els37645722_e_ls
ewes76328702_ewes
feels85223042feels
fells85327382fells
fowls115518892fowls
gels56836102ge_ls
heals85733452heals
heels85625532heels
heils85222192heils
hells85032042hells
herls85226432herls
hews105631572hew_s
howls116219222howls
jells125522162jells
jewels16508612jewels
jews145822082jew_s
jowls156214522jowls
keels94622412keels
lewis85315842lewis
mails76037782mails
malls76233432malls
marls75535162marls
mauls76524952mauls
maws96437142maw_s
meads85425322meads
meal65643172meal_
mealy104422182mealy
means75831232means
meats75034052meats
medals94218052medals
meds75735362me_ds
meeds84920272meeds
meets74224612meets
megs75530632me_gs
mel56047482me_l_
meld75830472me_ld
melds84822382melds
mell64935612me_ll
melt65752892me_lt
melts74930102melts
memes94927702memes
memos95719112memos
mems85931502me_ms
mends84927692mends
menus75822842menus
meous76120062meous
meows104612682meows
mercs96020452mercs
meres75143572meres
merks114722402merks
merl65830972merl_
merle75824372merle
merles85322762merles
mesas76823202mesas
mess65932432me_ss
metals84520882metals
metes74736212metes
meths105320232meths
metis75025902metis
metols84115772metols
mew86137732mew__
mewed115218012mewed
mewled123710052mewled
mewler113510232mewler
mewlers12288982mewlers
mezes167719262mezes
mills75435052mills
mils66045332m_ils
moils76125752moils
molls75129782molls
mols65948572m_ols
mools76027172mools
mows96340832mow_s
mulls75124152mulls
newels93710822newels
newly114610202newly
news76127372new_s
newts86015282newts
owls76022932_owls
pawls105617662pawls
peals75235492peals
peels75226422peels
pews95731532pew_s
reals55038652reals
reels55333262reels
seals54839692seals
seels55632822seels
sells55134432sells
sels46345982se_ls
sews75836022sew_s
smells83914742smells
smews104612292smew_s
teals56234132teals
teels55726372teels
tells55828942tells
tels46841692te_ls
tews76431642tew_s
veals84926192veals
veils84918802veils
wawls115416472wawls
weals85428742weals
wells85426192wells
yawls114613602yawls
yells85821942yells
yews105323962yew_s
yowls115715432yowls
zeals145320852zeals

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.313570897.8
2DLD Change Limit538001301.61033416.1
3Display Results1301300.0304333.3
 (SQL Overall)1786911301.95391495.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.