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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
ostiary103646(None) 
bestiary1344812bestiary
costmary1545052costmary
estuary1034682estuary
ossuary1043942ossuary
ostia52315582ostia__
ostmark1344872ostmark
retiary1038332retiary
vestiary1444312vestiary
actuary1245613actuary
antiar6317173antiar_
antiars7314623antiars
apiary113910383_apiary
ariary94114203_ariary
astir55517093asti_r_
astray95615543astra_y
aviary12338413_aviary
biliary1238213biliary
briary114912003_briary
ciliary1247923ciliary
contrary1347493contrary
costar85518613cost_ar_
costard104113353cost_ard
costars94218013cost_ars
datary10310243dat_ary
diary95016973__diary
estray95713333estra_y
friary124010093_friary
gossipry1441903gossipry
hosiery13337183hos_iery
hostelry1443913hostelry
laniary1068013laniary
miliary1249463miliary
mortary12369043mort_ary
mortuary1373923mortuary
notary92310713not_ary
obituary1342853obituary
obstinacy1651783obstinacy
octonary1344983octonary
olivary1345163olivary
ordinary1244913ordinary
osar46820953os__ar_
osier53518013os_ier_
osiers63412793os_iers
ossia53710403ossia__
ossify1244973ossi_fy
osteal6312963ostea_l
ostiaries948803ostiaries
ostinati846883ostinati
ostinato846493ostinato
ostiolar844583ostiolar_
ostiole739013ostiole
ostium8310133osti_um
ostler63312193ostler_
ostlers72911203ostlers
ostmarks1443893ostmarks
ostomy1137833ost_omy
ostraca937823ostraca
ostraka1144833ostraka
ottar54313993o_ttar_
ottars64112223o_ttars
outbark1339453outbark
outcry1137993out_cry
outdare83113403outdare
outearn7310683outearn
outlawry1443023outlawry
outlay92711793outla_y
outpray12268083outpray
outsay92611873outsa_y
outwar91011513outwar_
outward11811403outward
outwars10912793outwars
outweary1485393outweary
ovary1149113o__vary
ovulary1344913ovulary
postcard1346523postcard
postmark1645433postmark
postwar1236903postwar_
rosary92810353ros__ary
rosemary1344433rosemary
rotary92411303rot_ary
salary9515213_salary
scary105222593_s_cary
senary93716073_senary
sitar54820543_sitar_
sitars65417593_sitars
smeary114110803_smeary
solidary1245103solidary
solitary1146503solitary
spiry105017353_spi_ry
stagy96618893_st_agy
stair54719943_stair_
stairs65416333_stairs
star48037763_st_ar_
stare54440263_st_are
stark95425623_st_ark
starry94911673_starry
stars55836573_st_ars
start55642313_st_art
stay78333723_st_a_y
steady103510203_steady
steamy115112373_steamy
sticky154711343_sticky
stilly93714093_stilly
stimy105114743_sti_my
stingy105213203_stingy
stinky134611073_stinky
stir45723253_sti_r_
stirk95717413_sti_rk
stirp76815503_sti_rp
stirs55921623_sti_rs
stithy12398213_stithy
story86723033_st_ory
stoury9529943_stoury
strawy1210312823_strawy
stray88525573_stra_y
sudary1038703_sudary
sugary1039013_sugary
teary85124053__teary
tertiary1145433tertiary
tiara5315913__tiara
topiary1245813topiary
unitary1038613unitary
vespiary1642743vespiary
votary12248333vot_ary

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271258.45015861.2
3Display Results1251250.0333787.9
 (SQL Overall)1786911258.88920102.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.