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

55 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
statuary114403(None) 
stannary1144612stannary
stature74410682statu_re
statusy10455422statu_sy
statutory1242412statutory
actuary1245613_actuary
datary10310243_dat_ary
estuary1034683_estuary
manuary1237773_manuary
mortuary1373923mortuary
obituary1342853obituary
saguaro845513s_aguaro
sahuaro1044233s_ahuaro
salary9515213s_a_lary
salutary1145113s_alutary
sanctuary1442183sanctuary
satara6315533s_at_ara
satay84718463s_at_a_y
satrapy12497933s_atrapy
saury84317223s_a_u_ry
scapulary1643213scapulary
sectary1238273sect_ary
spatular1044663spatular_
staggard1144513staggard
staggart1046643staggart
staggery13346243staggery
stalwart1147193stalwart
standard1046253standard
starry94911673sta__rry
statal61613223stat_a_l
statant7313123stat_ant
statedly1245833statedly
stately10310223stat_ely
stater64427563stat_er_
staters73922343stat_ers
staticky1743233staticky
stationary1354153stationary
stator64015483stat_or_
stators73915583stat_ors
statuaries1054603statuaries
statue66015323statu__e
statued8459893statu_ed
statues74614903statu_es
statures83711113statures
status65515213statu__s
statuses8409543statuses
statute7419323statu_te
statutes8368893statutes
stoury9529943st_ou_ry
sumptuary1651703sumptuary
tatar56122063_tat_ar_
tatars64619793_tat_ars
tatouay1044113_tatoua_y
textuary1842673textuary
titulary1144873_titulary

Search took 9 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 Filter1786911461620.450397091.1
2DLD Change Limit146162557.80018738.7
3Display Results55550.0134230.8
 (SQL Overall)178691558.26321625.4
 
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.