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

128 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
turbary123638(None) 
bursary12397582bursary
durbar968722durbar_
durbars1077972durbars
ternary1038342ternary
turban8310482turba_n
turbans939562turbans
turnery10357422turnery
ambary134010543_ambary
ariary94114203_ariary
aurar54420253aur_ar_
briary114912003_briary
bulbar1039583bulbar_
burbly134311153burb_ly
burglary1473133burglary
burry105221563bur__ry
bursar85413253bursar_
bursars94510893bursars
busbar1038453busbar_
busbars1138153busbars
carbarn1139453carbarn
carbaryl1544423carbaryl
curably142010773curably
curacy1339593cur_acy
curara83712203cur_ara
curare84916953cur_are
curari84414403cur_ari
curber104517053curber_
curbers115514383curbers
curry105920343cur__ry
cursory12406393cursory
darbar959953darbar_
darbars10510093darbars
dreary104611673_dreary
durably13229053durably
forbare122310513forbare
friary124010093_friary
fubar1039923fu_bar_
furry116719283fur__ry
garbagy1444243garbagy
gurnard944773gurnard
gurry94515413gur__ry
horary12310383hor_ary
hurray12459913hurra_y
hurry114917183hur__ry
kurbash1643803kurbash
library1245323library
lumbar103610593lumbar_
lumbars11289763lumbars
mortary12369043mortary
murry105120233mur__ry
nummary14314653nummary
nursery10396023nursery
ourari63413543our_ari
outbark1339453outbark
quinary1936933quinary
rubbery14337593rubbery
rurban849043rurba_n
sudary1038703su_dary
sugary1039013su_gary
summary14297353summary
surbase939793surbase
surgery11319213surgery
tabard9313333t_abard
tanbark1337373tanbark
tarry85422513tar__ry
tartar63214753tartar_
tartare73012683tartare
tartars73313403tartars
teary85124053t__eary
terry84721873ter__ry
tertiary1145433tertiary
thready14435903thready
throaty13428483throaty
tilbury1242983tilbury
timbery14256893timbery
topiary1245813topiary
tray77632593t_r_a_y
treaty94414353t_reaty
trinary1039173trinary
tuatara745513tuatara
tuba65422363tu_ba__
tubae74716643tu_ba_e
tubal75517203tu_ba_l
tubas75119583tu_ba_s
tubate82813173tu_bate
tubber104313203tubber_
tubbers113411253tubbers
tubby124511403tu_b_by
tuber75420683tu_ber_
tubers85017033tu_bers
tunably12218293tunably
turaco839453tur_aco
turbaned1145623turbaned
turbaries1147743turbaries
turbeth1274713turbeth
turbid979713turb_id
turbidly1443683turbidly
turbine9310303turbine
turbit8715113turb_it
turbith1267113turbith
turbits969233turbits
turbo71015043turb__o
turbocar1243363turbocar_
turbocars1343073turbocars
turbos8910783turb_os
turbot8914263turb_ot
turbots988023turbots
turfy114315403tur__fy
turgor736863turgor_
turgors836833turgors
turkey1337763tur_key
turner63914613turner_
turners73912893turners
turnkey1433013turnkey
tushery1335633tushery
tussar6369543tussar_
tussars7359253tussars
tutelary1143573tutelary
unary8315993_u_nary
unbar71913613_unbar_
unbars82113033_unbars
unwary1239823_unwary
urare56322553_ur_are
urari54619963_ur_ari
urban72013863_urba_n
urbane82211383_urbane
urinary1037243_urinary

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271285.75023309.0
3Display Results1281280.0632031.7
 (SQL Overall)1786911286.23628654.7
 
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.