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

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

96 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
deejays184343(None) 
deejay1734521deejay_
veejays2042311veejays
decays124612912d_ecays
deejayed2042442deejayed
deewans11306902deewans
defrays1436112defrays
delays104014052d_elays
derays105514252d_erays
leeways1354452leeways
veejay1933702veejay_
belays114313853_belays
bendays13327513bendays
betrays12127823betrays
bewrays15145113bewrays
bluejays2042063bluejays
days87637133d___ays
deads75726913d_e_ads
deals65435343d_e_als
deans66131393d_e_ans
dears65736883d_e_ars
debags104211063d_ebags
debars94218043d_ebars
debeaks1436103debeaks
decafs124010883d_ecafs
decals93717713d_ecals
decay114718483d_ecay_
declass1038733declass
declaws1336253declaws
decoys123911283d_ecoys
dedans85915073d_edans
deeds75423763dee__ds
deedy104315893dee_dy_
deejaying2142753deejaying
deems85421773dee__ms
deepens10307813deepens
deeply1257013deeply_
deeps84921773dee__ps
deers64930523dee__rs
dees56356633dee___s
deets65330243dee__ts
deewan10267553deewa_n
defats105114553d_efats
defeats113511233defeats
defoams1336193defoams
defrags1236193defrags
defray1337643defray_
degas75119163d_ega_s
dejects17389223dejects
delay94820633d_elay_
deleads9379703deleads
deltas74414823delta_s
demeans1039723demeans
denars74621433d_enars
denials84114133denials
dentals83915393dentals
deodars937623deodars
deploys1336523deploys
derats74625063d_erats
deray95024183d_eray_
dermas94116813derma_s
desmans1039003desmans
devas96218883d_eva_s
dewans105215143d_ewans
dewars105117073d_ewars
dewlaps1334663dewlaps
deys85027473d_e__ys
dismays13237433dismays
drays95819773d__rays
dreads84115023dre_ads
dreams94513983dre_ams
drears74614253dre_ars
edemas9310503edema_s
edgeways1642583edgeways
embays131408333_embays
enjoys1644603_enjoys
essays965653_essays
freeways1744723freeways
geegaws1242343geegaws
heehaws1643343heehaws
heydays1734143heydays
jays146328343___jays
jetways2094053jetways
keyways2043373keyways
leeway1255883leeway_
prepays1437483prepays
redbays1336013redbays
reenjoys1842723reenjoys
relays94316753_relays
repays113813973_repays
replays12399763replays
resays93714153_resays
seaways13307513seaways
seesaws1034703seesaws
veenas91410413veena_s
weekdays1941433weekdays

Search took 8 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.390458182.1
2DLD Change Limit134027966.83019623.3
3Display Results96960.0462087.0
 (SQL Overall)178691967.26624592.8
 
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.