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

60 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
ostiaries94880(None) 
bestiaries1245972bestiaries
costmaries1446912costmaries
estuaries946212estuaries
ossuaries944552ossuaries
vestiaries1345372vestiaries
actuaries1147573actuaries
antiarins9413893antiarins
anticaries12412473anticaries
apiaries10312733_apiaries
aviaries1139783_aviaries
contraries12711933contraries
dataries9314033dat_aries
diaries83321953__diaries
friaries11310083_friaries
gossipries1352433gossipries
hosieries1249213hos_ieries
hostelries1345423hostelries
laniaries9411223laniaries
mortuaries1245373mortuaries
notaries8314933not_aries
obituaries1243343obituaries
obstinacies1572273obstinacies
octonaries1246003octonaries
ordinaries1146253ordinaries
ossifies1177563ossi_fies
ostiary1036463ostiar__y
ostioles839273osti_oles
ostmarks1443893ostmar_ks
ostomies10310583ost_omies
ostracise1146293ostracise
ostracises1245373ostracises
ostracizes2144723ostracizes
outcries10313573out_cries
outdares92712463outdar_es
outlawries1382883outlawries
outwearies1345353outwearies
ovaries10312653o__varies
retiarius945243retiarius
rosaries8312783ros__aries
rosemaries1246033rosemaries
rotaries8315693rot_aries
salaries8319593_salaries
solitaries10410123solitaries
stares66038753_st_ar_es
starves104614553_st_arves
steadies9311123_steadies
stearines9311283_stearines
stearins8312143_stearins
stickies142211973_stickies
stiffies14258383_stiffies
stimies9316563_sti_mies
stirpes95011293_sti_rpes
stithies1139233_stithies
stories7324273_st_ories
sudaries9312753_sudaries
tertiaries1047003tertiaries
topiaries1147113topiaries
vespiaries1543583vespiaries
votaries11312013vot_aries

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 Filter1786911486410.403443402.0
2DLD Change Limit148641606.29623608.8
3Display Results60600.0331818.2
 (SQL Overall)178691606.73226543.5
 
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.