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

116 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
delay9482063(None) 
belay105021521belay
decay114718481decay
delays104014051delays
delly96023871delly
deray95024181deray
relay84424671relay
allay85620392allay
belady12489932belady
belays114313852belays
belly104625492belly
clay95927412_clay
dally95324742dally
day76254112d__ay
dead65434242de_ad
deaf85838402de_af
deal56347412de_al
deals65435342deals
dealt65234282dealt
dean56039482de_an
dear55343602de_ar
deary95826842deary
debag94212302debag
debar85517862debar
decaf114919442decaf
decal85523232decal
decays124612912decays
declaw1266702declaw
decoy115716312decoy
decry115514352decry
dedal75719022dedal
deedy104315892deedy
deejay1734522deejay
defat95426692defat
defray1337642defray
defy114921262de_fy
degas75119162degas
deify124112762deify
deity94316772deity
del46752752del__
delate73827752delate
delayed123310762delayed
delayer113010532delayer
dele56843082del_e
delead84112342delead
deled75326542deled
deles65139252deles
delf85436572del_f
delfs94918672delfs
delft95623322delft
deli55631292del_i
delis64928542delis
dell56938202del_l
dells66630942dells
dels56745472del_s
delt57855272del_t
delta66117772delta
deltas74414822deltas
delts65731792delts
delve96018262delve
demy105422852de_my
denar65223292denar
denary105316862denary
deny86027122de_ny
deoxy1648882deoxy
deploy1237582deploy
derat65044082derat
derays105514252derays
derby114715342derby
derry94721372derry
deva85720982deva_
devas96218882devas
dewan95718042dewan
dewar95817732dewar
dewax165510852dewax
dewlap1264842dewlap
dewy115419022de_wy
dexy156118552de_xy
dey77243372de__y
dilly94923782dilly
dolly96125202dolly
dray85428092d_ray
dully94921632dully
duly85323032dul_y
eely77725212eel_y
elan46734242_elan
elmy95616792_elmy
felly114922802felly
flay106332802_flay
inlay85214322inlay
jelly154218252jelly
kelly124617022kelly
kelpy145110682kelpy
lay68865352__lay
mealy104422182mealy
melty104918362melty
nelly84618812nelly
onlay84212942onlay
play95928982_play
relax124817802relax
relays94316752relays
rely75428952rel_y
repay104818452repay
replay113412922replay
resay85320542resay
selah8319612selah
slay76436382_slay
splay105816042splay
tela45532972tela_
telae54323292telae
telly84920822telly
unlay84613702unlay
vealy115817772vealy
vela75725542vela_
velar85817632velar
welly114620012welly

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.1731032896.0
2DLD Change Limit538001161.89028465.6
3Display Results1161160.0303866.7
 (SQL Overall)1786911162.09385375.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.