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

161 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
taboret9291611(None) 
tabaret92717311tabaret
tabored102810561tabored
taborer9269291taborer
taborets10278061taborets
tabouret1049171tabouret
abort76133582_abor_t
cabaret112519042cabaret
labored102810252labored
laborer9249512laborer
labret8320222lab_ret
tabarets10287232tabarets
tabered103311592tabered
tablet84227642tab_let
tabooed10267382tabooed
tabor75518392tabor__
taborers10268332taborers
taborin92210452taborin
tabors84517112tabor_s
taboured1156272taboured
tabourer1035742tabourer
tabourets1144162tabourets
abet610547943_ab__et
abode85518813_abode_
aboded104912513_aboded
abodes94417513_abodes
aboral8314373_aboral
aborted10310423_aborted
aborter939933_aborter
aborts84916183_aborts
about75229083_abo_ut
above105414323_above_
aboves114512843_aboves
adore65723673_adore_
adored84714243_adored
adorer74713453_adorer
adores74420723_adores
afore85818603_afore_
agorot7415003_agorot
aigret73720023_aigret
amort75832203_amor_t
aport75432173_apor_t
arbored103811603arbored
arbores94016033arbores
arboreta1045223arboreta
avocet11412683_avocet
avoset9315673_avoset
baronet91022213baronet
barret84930493ba_rret
bayonet121212213bayonet
beret74946363__beret
bore66051333__bore_
bored85034303__bored
borer75131273__borer
bores76448253__bores
bort65960963__bor_t
buret77444013__buret
cabarets12268463cabarets
cabernet12410763cabernet
cabinet11318903cabinet
cablet104429463cab_let
carburet12411113carburet
caret75360563ca__ret
cavort11316173cavor_t
favored1455983favored
favorer1355883favorer
floret9321123_floret
galore73514873galore_
galores82614343galores
garret74426563ga_rret
harbored1438643harbored
harborer1348063harborer
jabot14321513jabo__t
jaconet16311483jaconet
jamboree1944863jamboree
labor75117313labor__
laborers10208383laborers
laborite10410703laborite
labors84016413labor_s
laboured1156333laboured
labourer1045763labourer
labrets939363lab_rets
lazaret16411783lazaret
majored1735853majored
rabbet103818653rab_bet
razored1736333razored
rebore86625653rebore_
rebored105015883rebored
rebores95319163rebores
sabered103213023sabered
sabot7931783sabo__t
sabre74821503sab_re_
sabred95916533sab_red
sabres85520863sab_res
savored1158343savored
savorer1057883savorer
tabard9313333tabar_d
tabarded1234743tabarded
tabards10310383tabards
tabbed114215363tab_bed
tabbied12297793tabbied
tabbies112913503tabbies
taber73825823tab__er
tabers84621573taber_s
tabes76033923tab__es
table75429603tab_le_
tabled94020043tab_led
tables84524893tab_les
tablets94714383tab_lets
taboo73418093tabo__o
tabooley1342993tabooley
taboos83815433tabo_os
taborine102510683taborine
taborines11238983taborines
taboring113010193taboring
taborins103310223taborins
tabouleh1342793tabouleh
tabouli945843tabouli
tabour84011323tabo_ur
tabourers1144673tabourers
tabours94110093tabours
tabued94310403tab_ued
tacet75840023ta__cet
tacket124627493ta_cket
tailored936203tailored
taloned8310223taloned
tamboured1443783tamboured
tambourer1343493tambourer
tanrec837813ta_nrec
tapered102612933tapered
taperer92511793taperer
tappet103820113ta_ppet
taproot9412673taproot
tare45957623ta__re_
tared69340053ta__red
tares57456563ta__res
target75028913ta_rget
tarot55943933ta__rot
tarre55825633ta_rre_
tarred74720283ta_rred
tarres64723043ta_rres
tart47566183ta__r_t
tartlet72218483tartlet
tasset65925313ta_sset
teaboxes1745063teaboxes
terret63425623t_erret
theorem1236273theorem
tore47359323t__ore_
tores55352673t__ores
torot56139943t__orot
tort46967463t__or_t
torte55431703t__orte
tret46653533t___ret
triolet73219523triolet
tsores65113663t_sores
turbojet1755383turbojet
turret63121853t_urret
tutored837553tutored
upbore10247883upbore_
vapored1336923vapored
vaporer1236983vaporer

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271616.58020368.8
3Display Results1611610.0602683.3
 (SQL Overall)1786911617.04625360.6
 
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.