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

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

94 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
suasory104604(None) 
cursory12406392cursory
savory124310562s_avory
sensory10329092sensory
succory1444642succory
sudatory1245842sudatory
amatory1238633amatory
bursary12397583bursary
calory11312843_calory
cursor84110293cursor_
cursors93910023cursors
elusory1083993elusory
flavory1644743flavory
fumatory1644923fumatory
juratory1845183juratory
masonry1244123_masonry
nugatory1245273nugatory
nursery10396023nursery
oratory1039403oratory
pastry114913033_pastry
quarry1837473qua_rry
quasar1536833quasar_
quasars1646903quasars
quavery22225483quavery
salary9515213s_alary
sapor75119253s_apor_
sapors84118813s_apors
sashay1238363s_ashay
sassy85813813s_as_sy
satori6415843s_atori
saury84317223s_a_ury
savor85417943s_avor_
savors95616103s_avors
savoury13365873s_avoury
savoy114713883s_avo_y
saxony1636233s_axony
scarry116311183sca_rry
scary105222593sca__ry
sealery104011053sealery
seaport9315603seaport
seashore1147723seashore
season62714903seaso_n
seasons72614233seasons
seisor63712343seisor_
seisors73212843seisors
sensor63813843sensor_
sensors73514643sensors
shadowy1744723shadowy
shamoy14379913shamo_y
signory11427523signory
slavery13407893slavery
sparry115111303spa_rry
squalor1644423squalor_
squalors1744583squalors
squashy2233843squas_hy
starry94911673sta_rry
stator64015483stator_
stators73915583stators
story86723033s__tory
suably112814533sua_bly
suasion739363suasion
suasions838783suasions
suasive1037853suasive
suavely1376493suavely
suaver93014233suaver_
suavity1336313suavity
suborn8310013su_born
subsere9311443subsere
subsidy1345973subsidy
subsoil967293subsoil
succor1036623succor_
succors1137413succors
sudary1038703su_dary
sudor6312623su_dor_
sudors7311103su_dors
sudser73511283sudser_
sudsers83310423sudsers
sudsy95010683suds__y
sugary1039013su_gary
suitor63311053suitor_
suitors73012493suitors
sulfury1345163sulfury
sultry938463su_ltry
summary14297353summary
summery14329413summery
sundry1057943su_ndry
support11310523support
surgery11319213surgery
tussor6378233tussor_
tussore7317283tussore
tussors7388773tussors
usury887623_u_sury
vapory14398763_vapory
wastry12388773_wastry

Search took 8 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 Filter1786911340270.423422437.4
2DLD Change Limit134027947.29618369.9
3Display Results94940.0303133.3
 (SQL Overall)178691947.74923059.9
 
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.