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

122 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
sarod6532587(None) 
sard55344241sar_d
sarode75317511sarode
sarods74918571sarods
saros55238061saros
scrod85115061scrod
apod78123182_apod
arid57642712_arid
aroid65428332_aroid
bard75648862bar_d
bared85144482bared
baron78131242baron
card710245872car_d
cared86050092cared
carob95325222carob
carol75128612carol
carom95025562carom
dared75935012dared
eared65139502eared
farad95720672farad
fard85639062far_d
fared95842342fared
faro76136922faro_
faros85532022faros
hard85443502har_d
hared95742182hared
karoo92519582karoo
lard56742002lar_d
nard56634452nar_d
oared65030652oared
pagod95013682pagod
pard76441322par_d
pared86946762pared
parody12410092parody
parol74826272parol
prod76129502_prod
ramrod936832ramrod
rared65738322rared
rod47953892__rod
sabed86526812sabed
sabot7931772sabot
sabred95916532sabred
sacred94917102sacred
sad47459202sa__d
safrol937282safrol
sago56332672sago_
sagos66123872sagos
said55742112sa_id
sajou12311692sajou
salad65321832salad
salol55222142salol
salon55228552salon
sand55338462sa_nd
saned65636272saned
sapid84720932sapid
sapor75119252sapor
saran53730302saran
sarcoid10310452sarcoid
sards64736182sards
saree55044662saree
sarge65531132sarge
sargo65424412sargo
sargos74318272sargos
sari45444042sar_i
sarin55239252sarin
saris54544952saris
sark84938972sar_k
sarks96632462sarks
sarky125521782sarky
sarodes84216142sarodes
sarong73914872sarong
sartor6313872sartor
sated66238532sated
saved95127112saved
savor85417942savor
savoy114713882savoy
sawed95628402sawed
sayed96127142sayed
sayid95516722sayid
scared95227292scared
schrod1247882schrod
scrods94111602scrods
seared75232842seared
sered65737292sered
serow86720442serow
shard96125962shar_d
shared105829062shared
shod86225052s_hod
shred98125612shred
shroud1038762shroud
sired66134282sired
snared74824552snared
snood64616162snood
soared74324292soared
sod46053702s__od
sord56237202sor_d
sored66141782sored
spared95427482spared
sparid94016932sparid
sparoid102311532sparoid
stared75429872stared
stood65517712stood
strode75215972strode
strop77422242strop
stroud7310382stroud
strow88920572strow
stroy87720392stroy
surd56433812sur_d
sward94221462swar_d
sword95214112sword
synod9610282synod
tardo65321102tardo
tared69340052tared
taro46846912taro_
taroc75721642taroc
tarok97921072tarok
taros55640822taros
tarot55943932tarot
trod57627952_trod
ward86542252war_d
wared96339872wared
yard85633252yar_d

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.0931921408.6
2DLD Change Limit538001222.01626686.5
3Display Results1221220.0304066.7
 (SQL Overall)1786911222.13983539.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.