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

112 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
veejay193370(None) 
deejay1734521deejay
veejays2042311veejays
deejays1843432deejays
leeway1255882leeway
veena81912322veena_
veenas91410412veenas
veery115816252vee_ry
beechy16397503beechy
beefy135313833bee_fy
beery105220123bee_ry
belay105021523_belay
benday123810813benday
betray111511443betray
bewray14147733bewray
bluejay1942723bluejay
decay114718483_decay
deedy104315893dee_dy
deejayed2042443deejayed
deeply1257013deeply
deewan10267553deewan
defray1337643defray
delay94820633_delay
deray95024183_deray
eely77725213_ee_ly
eery76129623_ee_ry
embay123410603_embay
enjoy1545963_enjoy
essay867623_essay
evenly1236993evenly
every115215453eve_ry
feebly1436653feebly
freeway1635603freeway
geegaw1142853geegaw
geeky134710733gee_ky
heehaw1543933heehaw
heyday1635143heyday
jay136242673___jay
jetway19105273jetway
keenly1336373keenly
keyway1943823keyway
leery85919133lee_ry
leeways1354453leeways
meekly1535193meekly
meetly1138673meetly
needy94614693nee_dy
overjoy2034873overjoy
overlay132410833overlay
overpay15228263overpay
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
veal76936813v_e_al
vealy115817773v_ealy
vee65750183vee___
veep95325093vee__p
veepee11311483veepee
veeps104715723vee_ps
veer76229573vee__r
veered103612743veered
veers84521363vee_rs
vees75439433vee__s
vegan95114153v_egan
vegetal1156303vegetal
veinal93812963veinal
veiny115414363v_einy
vela75725543v_ela_
velar85817633v_elar
vena76126293v_ena_
venae85920983v_enae
venal85523213v_enal
venery123710663venery
venial94218283venial
vera76828843v_era_
verbal112513663verbal
verify153110163verify
verily122616053verily
verity123714853verity
vernal93514213vernal
versal93013753versal
very108025643v_e_ry
vesta86618303vesta_
vestal94615573vestal
vestas95916683vestas
vestry1238623vestry
veteran1039353veteran
vexedly2143463vexedly
viewy14518103vie_wy
virelay1335943virelay
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.376475242.0
2DLD Change Limit1127161125.32621163.3
3Display Results1121120.0462434.8
 (SQL Overall)1786911125.74831087.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.