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 “thrusters” 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
thrusters124533(None) 
thruster1135791thruster_
thrustors1244301thrustors
trusters83112261t_rusters
thirsters1235232thirsters
thrashers1565312thrashers
threshers1545422threshers
throwsters1642712throwsters
thrummers1642412thrummers
thrushes1436522thrushe_s
thrusted1265222thruste_d
thrustor1144122thrustor_
thrusts10226522thrust__s
trussers8348282t_russers
trustees8339322t_rustees
truster73114312t_ruster_
trustors8268912t_rustors
trysters11298372t_rysters
adjusters1744163adjusters
arresters948193arresters
balusters1136643balusters
blusters104413893_blusters
bruiters10329143_bruiters
brushers134210573_brushers
bursters1038983bur_sters
busters94724133__busters
chaunters1455823chaunters
choristers1586103choristers
chousers134610203chous_ers
christens14125413christens
chunters133910903ch_unters
clusters102912403_clusters
crushers134010093_crushers
delusters1035983delusters
dusters84918363__dusters
exhausters2042403exhausters
flusters113811503_flusters
foresters12312533foresters
fruiters11328183_fruiters
gristers94013403_gristers
grunters9359033_grunters
hamsters13710423_hamsters
haunters11329543_haunters
heisters113413133_heisters
hipsters13268793_hipsters
hoisters113513483_hoisters
holsters113211943_holsters
housers104717813_hous_ers
hunters103915733_h_unters
hurters103413643_h_urters
huskers143510043_h_uskers
hustlers11349203_h_ustlers
jousters153210423_jousters
justers143815733__justers
lusters73921443__lusters
musters94522513__musters
ousters74122793__ousters
perusers10328803perus_ers
presters103419003_presters
rasters74629023__rasters
resters74130403__resters
rosters73727543__rosters
rousters84315683_rousters
rushers103816103__rushers
rustlers8339853__rustlers
shouters113510623shou_ters
shunters113210753sh_unters
shushers14267053sh_ushers
shutters113611353sh_utters
shysters14106463sh_ysters
strutters955693strutters
tapsters10318803t_apsters
tarsiers8298533tar_siers
tasters74225643t__asters
taunters8259273t_aunters
teamsters1135973teamsters
testers74124543t__esters
theaters114211903th_eaters
thirster1135673thirster_
thrasher1455743thrasher_
thrashes1487653thrashe_s
threaders1365743threaders
threapers1444773threapers
threatens1254673threatens
thresher1455823thresher_
threshes1437383threshe_s
thrillers1244473thrillers
thrivers14456823thr_ivers
throbbers1643173throbbers
throstles1265903throstles
throttlers1352483throttlers
throwers14106033thr_owers
throwster1542953throwster_
thrummer1542933thrummer_
thrust91911893thrust___
thrustful1552273thrustful
thrusting1335013thrusting
thumpers15365713th_umpers
thunders1236953th_unders
thurifers1542913thurifers
thwarters1542843thwarters
thyristors1652513thyristors
tipsters10278513t_ipsters
toasters83912723t_oasters
touters74018353t_ou_ters
trashers113013643t_rashers
treaters83615843t_reaters
trotters83310243t_rotters
trousers83910633trous_ers
truckers14279013t_ruckers
trudgers10256863t_rudgers
trusser74010263t_russer_
trusses73813643t_russe_s
trusted83412793t_ruste_d
trustee73514443t_ruste_e
trusteed9346533t_rusteed
trustier8268683t_rustier_
trusties82712853t_rusties
trustless955953t_rustless
trustor7238413t_rustor_
trusts64714433t_rust__s
tryster10369513t_ryster_
trystes10419993t_ryste_s
tufters10298353t__ufters
tuskers113710043t__uskers
tussers74313563t__ussers
twisters11268173t_wisters
wresters112711733_wresters

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.450397091.1
2DLD Change Limit1486411286.28323657.6
3Display Results1281280.0632031.7
 (SQL Overall)1786911286.79626293.6
 
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.