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

177 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
deejay173452(None) 
deejays1843431deejays
veejay1933701veejay
decay114718482d_ecay
deedy104315892dee_dy
deejayed2042442deejayed
deeply1257012deeply
deewan10267552deewan
defray1337642defray
delay94820632d_elay
deray95024182d_eray
leeway1255882leeway
veejays2042312veejays
beechy16397503beechy
beefy135313833bee_fy
beery105220123bee_ry
belay105021523_belay
benday123810813benday
betray111511443betray
bewray14147733bewray
bluejay1942723bluejay
daedal849083daedal
daresay1135433daresay
day76254113d___ay
dead65434243d_e_ad
deadly113811473deadly
deaf85838403d_e_af
deafly13389123deafly
deal56347413d_e_al
dean56039483d_e_an
dear55343603d_e_ar
dearly104615323dearly
deary95826843d_eary
deathy134210233deathy
debag94212303d_ebag
debar85517863d_ebar
debeak1336763debeak
decaf114919443d_ecaf
decal85523233d_ecal
decays124612913d_ecays
decenary1446273decenary
decency1537453decency
declaw1266703declaw
decoy115716313d_ecoy
decry115514353d_ecry
decury1277963decury
dedal75719023d_edal
dee47665823dee___
deed65340903dee__d
deeded94615543deeded
deeds75423763dee_ds
deejaying2142753deejaying
deem75432893dee__m
deemed104713063deemed
deems85421773dee_ms
deep76031883dee__p
deepen9339193deepen
deeper93613503deeper
deeps84921773dee_ps
deer56739023dee__r
deerfly1443983deerfly
deers64930523dee_rs
dees56356633dee__s
deet57356583dee__t
deets65330243dee_ts
deewans11306903deewans
defat95426693d_efat
defeat103817163defeat
defoam1238563defoam
defrag1136463defrag
defrays1436113defrays
deftly1336533deftly
defy114921263d_e_fy
degas75119163d_egas
deify124112763d_eify
deity94316773d_eity
deject164512843deject
delays104014053d_elays
delead84112343delead
delegacy1543533delegacy
delly96023873d_elly
delta66117773delta_
deltas74414823deltas
demean9510563demean
demy105422853d_e_my
denar65223293d_enar
denary105316863denary
denial74720513denial
dental74319173dental
deny86027123d_e_ny
deodar837713deodar
deoxy1648883d_eoxy
deploy1237583deploy
deputy12426713deputy
derat65044083d_erat
derays105514253d_erays
derby114715343d_erby
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
derry94721373d_erry
descry1256183descry
desman9311693desman
desoxy1744623desoxy
deva85720983d_eva_
devas96218883d_evas
dewan95718043d_ewan
dewar95817733d_ewar
dewax165510853d_ewax
dewily1338343dewily
dewlap1264843dewlap
dewy115419023d_e_wy
dexy156118553d_e_xy
dey77243373d_e__y
dietary1158663dietary
dismay12229473dismay
dray85428093d__ray
dread74419023dre_ad
dream85120393dre_am
dreamy12509993dreamy
drear65016903dre_ar
dreary104611673dreary
drecky16486333drecky
dreggy12364633dreggy
dressy10518143dressy
dweeby1542993dweeby
edema8610553edema_
edemas9310503edemas
eely77725213_ee_ly
eery76129623_ee_ry
embay123410603_embay
enjoy1545963_enjoy
essay867623_essay
feebly1436653feebly
freeway1635603freeway
geegaw1142853geegaw
geeky134710733gee_ky
heehaw1543933heehaw
heyday1635143heyday
jay136242673___jay
jetway19105273jetway
keenly1336373keenly
keyway1943823keyway
leery85919133lee_ry
leeways1354453leeways
meekly1535193meekly
meetly1138673meetly
needy94614693nee_dy
peery105719443pee_ry
prepay13310313prepay
redbay1238333redbay
reechy14367823reechy
reedy910020293ree_dy
reefy114217703ree_fy
reeky125416263ree_ky
reenjoy1743293reenjoy
relay84424673_relay
repay104818453_repay
replay113412923replay
resay85320543_resay
seaway12309993seaway
seedy94821533see_dy
seely84522633see_ly
seemly1138433seemly
seepy104717973see_py
seesaw935973seesaw
teensy9478273teensy
teeny85417883tee_ny
veena81912323veena_
veenas91410413veenas
veery115816253vee_ry
weedy125115003wee_dy
weekday1841963weekday
weekly1635313weekly
weensy12416823weensy
weeny115316163wee_ny
weepy134212593wee_py

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127161775.37620966.5
3Display Results1771770.0463847.8
 (SQL Overall)1786911775.81230745.2
 
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.