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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
joeys1551804(None) 
joes116635891joe_s
joey145719331joey_
joys146624661jo_ys
beys913829552_beys
bogeys124510912bogeys
boys96737332bo_ys
coeds85920162coeds
coneys115218422coneys
cooeys114914482cooeys
coseys115215812coseys
coveys145413502coveys
coys97537242co_ys
cozeys204610912cozeys
deys85027472_deys
doers65225712doers
does56554472doe_s
dogeys115510662dogeys
fleys117015602fleys
foes76543442foe_s
fogeys13509262fogeys
foleys123810462foleys
foys105628292fo_ys
gleys96514852gleys
goers65520252goers
goes55644092goe_s
goys86328412go_ys
greys96614852greys
hoers85724922hoers
hoes75755732hoe_s
homeys145012872homeys
honeys124016082honeys
hooeys125512312hooeys
hoseys124614002hoseys
hoys107733932ho_ys
jays146328342j_ays
jeeps144715372jeeps
jeers124818132jeers
jees115938542j_ees
jess116022032j_ess
jets115834102j_ets
jews145822082j_ews
jobs136529432jo_bs
jockeys23365952jockeys
jocks185118082jocks
joe106642352joe__
jogs127129332jo_gs
johns15398712johns
joins125818412joins
jokers175511192jokers
jokes165423332jokes
jokey195014692jokey_
joky186215312joky_
joles125230832joles
jolts125018882jolts
jones125028182jones
joss115925592jo_ss
jotas125717442jotas
jots116336142jo_ts
jouks165612342jouks
jowls156214522jowls
jows146632092jo_ws
joy137036362jo_y_
joyed164811832joyed
keys116322162_keys
koels94613902koels
leys76430182_leys
loess55714702loess
looeys95110122looeys
moneys115513622moneys
moseys114711702moseys
noels56418702noels
noes45845392noe_s
obeys107010642obeys
oes35866192_oe_s
oyes74940132_oyes
poems95715552poems
poesy105014062poesy
poets76024442poets
pogeys124110352pogeys
pokeys15529512pokeys
polys105718762polys
preys105717782preys
queys17398362queys
roes45954142roe_s
soys75233932so_ys
toeas55726422toeas
toes46956442toe_s
toys78036342to_ys
treys85018212treys
voes75432822voe_s
wheys145911552wheys
woes76440662woe_s
zoeas145815612zoeas

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.296603685.8
2DLD Change Limit53800941.70331591.3
3Display Results94940.0332848.5
 (SQL Overall)178691942.03287938.5
 
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.