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

104 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
abreact1131082(None) 
abreacts1245631abreacts
abreast9311271abreast
abject17137702abje_ct
abreacted1444292abreacted
abroach1446212abroach
bract96332722_br_act
breach134213722_breach
breast8319632_breast
preact103220392_preact
react74634332__react
abaca95118043ab__aca
abaci94718843ab__aci
aback134816173ab__ack
abaft10318063ab__aft
abbacy1536623ab_bacy
abduct11108543ab_duct
abeam9316533ab_ea_m
aberrant1049543aberrant
abet610547943ab_e__t
abeyant1248083abeyant
ablaut8313263ab_laut
ableist9311773ableist
ablest84721833able_st
abradant1147213abradant
abrade9313053abr_ade
abreacting1544533abreacting
abreaction1444653abreaction
abroad9310943abroa_d
abrupt1039943abr_upt
absence1137703absence
absent84016993abse_nt
abstract1249223abstract
abwatt11410673ab_watt
acreage1037833acreage
advect12309123adve_ct
affect1448903affe_ct
afreet9315153afre_et
airest63825263aire_st
already1144263already
area45843393a_rea__
areae55229743a_rea_e
areal55928733a_rea_l
areas55935773a_rea_s
areca75618633a_re_ca
arecas84817443a_recas
areic73219393a_reic_
arhat8327093a_rha_t
arrack121110253a_rrack
arrant6623253a_rrant
arrear6310253arrea_r
arrears738843arrears
arrest63722633arre_st
artefact1345183artefact
aspect10612823aspe_ct
attract9511833attract
aureate72515283aureate
bareback1846093bareback
barefit1249723barefit
barest85327693bare_st
barrack1538253barrack
beach124623893_b_each
beast76338643_b_east
beat66168303_b_ea_t
beaut75135213_b_eaut
bleach133611403_bleach
bleat75737003_blea_t
brace95629273_br_ace
brach126123303_br_ach
bracts105617773_br_acts
brant74742173_br_ant
brat66055543_br_a_t
bread85523113_brea_d
breads95419203_breads
breadth1365993_breadth
bready124511183_bready
break115319403_brea_k
breaks124816423_breaks
bream95121813_brea_m
breams104815043_breams
breasts939703_breasts
breath113916263_breath
breech13348263_breech
brent75734133_bre_nt
brevet115717333_brevet
broach133611113_broach
direct93817333dire_ct
dreamt94615713_dreamt
erect74129333_ere_ct
great66034243_grea_t
hereat93527413herea_t
labret8320223labre__t
object17135803obje_ct
obtect10129633obte_ct
overact12315043overact
preach133613923_preach
preacts113211363_preacts
reach105123883__reach
reacts83616603__reacts
redact9419043__redact
threat95020463threa_t
tract75635713_tr_act
treat56240353_trea_t
upreach1444693upreach

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.1561145455.1
2DLD Change Limit1340271046.75019855.9
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.95225703.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.