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

134 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
skated11441487(None) 
sated66238531s_ated
seated75131051seated
skate94721541skate_
skater105015481skater
skates104219391skates
skited114313471skited
slated75028311slated
stated75427831stated
abated95918452abated
alated75625142alated
bated85935532_bated
boated94221972boated
coated94927032coated
crated94827772crated
dated75530992_dated
doated84118182doated
elated74725822elated
estated83715572estated
fated95632132_fated
gated75329772_gated
grated84523922grated
hated95734022_hated
heated104525592heated
kited105120092_kited
lated65240672_lated
mated85537782_mated
meated94222402meated
moated94819002moated
okayed1434252okayed
orated74221502orated
pated85237842_pated
plated95225772plated
prated94924922prated
rated65441382_rated
sabed86526812s_abed
salted74121202salted
saned65636272s_aned
sate45556102s_ate_
satem76021452s_atem
sates54949322s_ates
sauted74119602sauted
saved95127112s_aved
sawed95628402s_awed
sayed96127142s_ayed
scaled94822442scaled
scanted104114392scanted
scaped115519552scaped
scared95227292scared
scarted104816122scarted
scathed134012642scathed
scatted103512772scatted
seabed95017692seabed
sealed74328362sealed
seamed94823882seamed
seared75232842seared
seater64534152seater
sedated93714342sedated
shaded114518872shaded
shafted14288802shafted
shaled105023952shaled
shamed125120212shamed
shaped125020102shaped
shared105829062shared
shaved135118382shaved
shawed134817232shawed
shuted103913162shuted
sifted104313672sifted
silted74020012silted
sited65130742s_ited
skald104210172ska_ld
skanked11338102skanked
skat87037892skat__
skaters113512942skaters
skatol1035712skatol
skats94621532skat_s
skeed105018982sk_eed
skewed145610232skewed
skied104417752sk_ied
skirted12388612skirted
skite95120042skite_
skites104418032skites
skived14429892skived
skoaled12226042skoaled
skyed13529922sk_yed
slaked114318272slaked
slanted83514742slanted
slate55438282slate_
slater64429182slater
slates64934062slates
slatey95417062slatey
slatted84015182slatted
slaved104017042slaved
slayed104716222slayed
smarted105012612smarted
snaked115017592snaked
snared74824552snared
snawed104813732snawed
soaked114717592soaked
soaped95817972soaped
soared74324292soared
solated83618022solated
sooted73922582sooted
sorted74523712sorted
sotted74121392sotted
spaced114517252spaced
spaded103816752spaded
spaed85522272spa_ed
spared95427482spared
spate74731582spate_
spates85028172spates
spathed134013182spathed
spatted104014142spatted
spayed124213612spayed
spited94820442spited
staged84521562staged
staked114621942staked
staled74728102staled
staned74824642staned
stared75429872stared
started84217322started
state56237332state_
stater64427552stater
states64337082states
statued8459892statued
staved103918052staved
stayed104817272stayed
suited74019422suited
swaged114212252swaged
swathed144611932swathed
swatted114110692swatted
swayed133510262swayed
sweated113411542sweated
teated74924022teated

Search took 4 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 Filter178691825510.1061685764.2
2DLD Change Limit825511343.36024568.8
3Display Results1341340.0931440.9
 (SQL Overall)1786911343.55950208.2
 
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.