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 “abated” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
abated9591845(None) 
abased96514991abased
abate76627841abate_
abater85518121abater
abates85825041abates
ablated102513441ablated
alated75625151alated
bated85935531_bated
aahed917816442a_ahed
abase76023482abase_
abaser86414342abaser
abases85720772abases
abashed1357662abashed
abaters95115202abaters
abatis84317942abatis
abator84512732abator
abed79734132ab__ed
abetted1058332abetted
abided105313312abided
ablate82219212ablate_
ablates92416912ablates
abled86926832ab_led
abluted10188362abluted
aboded104912512aboded
aborted10310422aborted
abraded1138642abraded
abused95614272abused
abutted1056982abutted
acted88521742a_cted
adapted1135852adapted
aerated85322382aerated
agate66525152agate_
agates76121342agates
airted74214502airted
alate55340332alate_
alates64833972alates
amazed18519312amazed
ansated84214002ansated
anted66328242a_nted
aurated83817792aurated
aviated11310272aviated
awaited1146962awaited
awaked14579202awaked
azoted16388592azoted
baaed85218162_baaed
baited95319242baited
baked126130772_baked
baled85436442_baled
baned85436352_baned
bared85144482_bared
based85331582_based
basted95227232basted
bate66552422_bate_
bates75846342_bates
bathed125518742_bathed
batted95623652batted
bayed115423022_bayed
boated94221972boated
coated94927042coated
crated94827772crated
dated75530992_dated
debated113916082debated
doated84118182doated
elated74725822elated
fated95632132_fated
gated75329772_gated
grated84523922grated
habited1337882habited
hated95734022_hated
heated104525592heated
labiated11109302labiated
lanated8313202lanated
lated65240672_lated
lobated102610942lobated
mated85537782_mated
meated94222402meated
moated94819002moated
orated74221502orated
pated85237842_pated
plated95225772plated
prated94924922prated
rated65441382_rated
rebated103619702rebated
sated66238532_sated
seated75131062seated
skated114414882skated
slated75028312slated
stated75427832stated
teated74924022teated
unabated11310132unabated
unbated103317732unbated
vacated1349352vacated

Search took 7 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 Filter178691825511.220146468.0
2DLD Change Limit82551925.15616010.7
3Display Results92920.0303066.7
 (SQL Overall)178691926.40627894.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.