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

35 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
topiaries114711(None) 
apiaries10312732_apiaries
aviaries1139783_aviaries
covaries13413253co_varies
diaries83321953__diaries
expiries1747753expi_ries
fopperies1666013fopperies
friaries11310083_friaries
hosieries1249213hosieries
laniaries9411223laniaries
lapidaries1345073lapidaries
moperies12313873mop_eries
notaries8314933no_taries
opiates9312143_opia_tes
ostiaries948803ostiaries
ovaries10312653_o_varies
paries84742513__p_aries
podiatries1345853podiatries
poperies12316793pop_eries
roperies10315763rop_eries
rosaries8312783ro_saries
rotaries8315693ro_taries
solitaries10410123solitaries
ternaries9311643ternaries
tertiaries1047003tertiaries
toadies82914863to__adies
toggeries1146213toggeries
topazes1857313top_a_zes
topiary1245813topiar__y
topsails1075093topsa_ils
tories65435883to___ries
turbaries1147743turbaries
typifies1644963typi_fies
vespiaries1543583vespiaries
votaries11312013vo_taries

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 Filter1786911486410.406440125.6
2DLD Change Limit148641356.62322443.2
3Display Results35350.0162187.5
 (SQL Overall)178691357.04525364.2
 
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.