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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
thrashers156531(None) 
thrasher1455741thrasher_
thrashes1487651thrashe_s
threshers1545421threshers
trashers113013641t_rashers
crashers134013232_crashers
rashers104020912__rashers
thrashed1555362thrashe_d
thresher1455822thresher_
threshes1437382threshe_s
thrushes1436522thrushe_s
thrusters1245332thrusters
trasher104416132t_rasher_
trashes104119262t_rashe_s
bashers124820833__bashers
brasher124515243_brasher_
brashes124518463_brashe_s
brasiers103710513_brasiers
brushers134210573_brushers
chasers123714923ch_as_ers
cherishers1854553cherishers
clashers134213993_clashers
crasher124616163_crasher_
crashes124618403_crashe_s
crushers134010093_crushers
dashers115016863__dashers
erasers74413943_eras_ers
flashers143912653_flashers
graspers11338403_graspers
harassers1246203harassers
harshens1437603_harshens
harsher13310363_harsher_
hashes125024803_h_ashe_s
heathers143914733_heathers
kashers143914023__kashers
lashers104121833__lashers
mashers124621053__mashers
phrases12711463phras_e_s
plashers133813453_plashers
quashers20186813_quashers
rasers64526783__ras_ers
rasher95024123__rasher_
rashes95330153__rashe_s
raspers94415923__raspers
rasters74629023__rasters
rushers103816103__rushers
sheathers1557553sheathers
shushers14267053sh_ushers
slashers113313613_slashers
smashers13339593_smashers
splashers1445283splashers
squashers21184983squashers
swashers14389533_swashers
tarsiers8298533tar_siers
tasters74225643t__asters
teachers133212393t_eachers
teasers75317243t_eas_ers
thalers106212263th_a_lers
thankers15297833th_ankers
thatchers1744583thatchers
thawers13428483th_a_wers
theaters114211903thea_ters
thirsters1235233thirsters
thrash12258363thrash___
thrashing1635683thrashing
thrashings1742783thrashings
thraves13469713thra_ve_s
threaders1365743threaders
threapers1444773threapers
threshed1535643threshe_d
thrillers1244473thrillers
thrivers14456823thr_ivers
throbbers1643173throbbers
throwers14106033thr_owers
throwsters1642713throwsters
thrummers1642413thrummers
thruster1135793thruster_
thrustors1244303thrustors
thwackers2142223thwackers
thwarters1542843thwarters
toasters83912723t_oasters
tracers94917843t_ra_cers
tracheas13410273t_racheas
trackers143512853t_rackers
traders84316953t_ra_ders
trailers82912933t_railers
trainers83114653t_rainers
trampers123210393t_rampers
transfers1238053t_ransfers
trappers123711043t_rappers
trashed113514703t_rashe_d
trashier113210103t_rashier_
trasses74819323t_rasse_s
trawlers113310203t_rawlers
trussers8348283t_russers
trusters83112263t_rusters
trysters11298373t_rysters
washers134517523__washers

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.423422437.4
2DLD Change Limit148641986.39023261.5
3Display Results98980.0462130.4
 (SQL Overall)178691986.85926052.0
 
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.