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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

185 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
rosters7372754(None) 
costers94128331costers
fosters104220101fosters
posters93928011posters
rasters74629021rasters
resters74130401resters
roasters83615931roasters
roisters83615551roisters
roosters83514661roosters
rooters74522931rooters
roster64329081roster_
rotters74421391rotters
rousters84315681rousters
routers74822871routers
roysters113610531roysters
zosters163015411zosters
asters65631602_asters
basters94930302basters
bisters93922612bisters
boasters103915662boasters
boaters93419242boaters
bolsters103712452bolsters
bolters94017802bolters
boosters104013442boosters
busters94724132busters
casters94729902casters
coasters104317332coasters
coaters93525792coaters
colters93522442colters
cooters94525722cooters
copters113621282copters
coshers123618182coshers
costars94218012costars
coster84331292coster_
cotters94323442cotters
couters93827302couters
crofters13358902crofters
crosiers103312062crosiers
crossers103912702crossers
dosers75723632dos_ers
dossers84516232dossers
doters74423912do_ters
dotters83715972dotters
dusters84918362dusters
easters75125682easters
esters64627732_esters
festers104121392festers
footers104618332footers
foster94322222foster_
frosteds12305652frosteds
gasters85624292gasters
goiters84014442goiters
gristers94013402gristers
grossers94410972grossers
grouters95910082grouters
hoisters113513482hoisters
holsters113211942holsters
hooters104520472hooters
hosers95223962hos_ers
hosiers104212642hosiers
hostels103712312hostels
hostess103210242hostess
hostlers113310482hostlers
jesters144118192jesters
jolters143711992jolters
joshers174111592joshers
jostlers15357682jostlers
jotters143413802jotters
jousters153210422jousters
justers143815732justers
koshers144811802koshers
lasters75627692lasters
listers74026532listers
lobsters10268742lobsters
lofters103912902lofters
loiters74116612loiters
looters74419162looters
losers65123582los_ers
lotters73921062lotters
lusters73921442lusters
masters94628922masters
misters93927512misters
mobsters12359062mobsters
molters93816972molters
monsters103314552monsters
mooters93818622mooters
moshers124017842moshers
mossers94116192mossers
musters94522512musters
nesters74422792nesters
noshers103614332noshers
noters64021002no_ters
oaters65029792_oaters
osiers63412792_osiers
ostlers72911202_ostlers
otters64021512_otters
ousters74122792ousters
outers64230172_outers
oxters134813272_oxters
oysters103411692oysters
pasters94531732pasters
pesters93827092pesters
porters93722702porters
posers84223972pos_ers
poster84129172poster_
postern93615612postern
posterns102713722posterns
potters94024342potters
pouters94221872pouters
powters124015662powters
presters103419002presters
prosers94219642pros_ers
prospers123012262prospers
rafters103715632rafters
ranters73323642ranters
rasers64526782ras_ers
rashers104020912rashers
raspers94415922raspers
raster64731442raster_
raters63936582r_aters
ratters74422472ratters
renters74224812renters
rester63832432rester_
rioters73615512rioters
risers64624782ris_ers
riskers114011992riskers
ritters74020622ritters
roadsters1035102roadsters
roamers93713462roamers
roarers73812742roarers
roaster74116662roaster_
robbers112814162robbers
rockers133916552rockers
rogers74517912ro_gers
roister73516202roister_
rolfers104011812rolfers
rollers73117472rollers
rompers113412242rompers
roofers105013902roofers
roomers95416412roomers
roosers74217872roosers
rooster74415172rooster_
rooter64926032rooter_
ropers84325902ro_pers
rosery93813282ros_ery
roses56445772ros_e_s
rosets65819952ros_ets
rosier64221262rosier_
rostra6310932rost_ra
rotes56143902ro_te_s
rotors64917952ro_tors
rotter64325462rotter_
rottes64524832rotte_s
rousers75220142rousers
rouster73517082rouster_
router65025842router_
routes66129312route_s
rovers95423522ro_vers
rowers94924572ro_wers
royster103110532royster_
rozzers1535632rozzers
rushers103816102rushers
rustlers8339852rustlers
sisters73721592sisters
sorters74221132sorters
souters74422602souters
tasters74225642tasters
testers74124542testers
toasters83912722toasters
tooters73818772tooters
tossers74713502tossers
toters65026362to_ters
totters74618732totters
touters74018352touters
trotters83310242trotters
trusters83112262trusters
trysters11298372trysters
ulsters72711982ulsters
voters95017442vo_ters
wasters104026592wasters
westers105221962westers
wresters112711732wresters
xysters17307162xysters
zesters163517292zesters
zoster153715852zoster_

Search took 5 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 Filter1786911076710.390458182.1
2DLD Change Limit1076711853.67329314.2
3Display Results1851850.0603083.3
 (SQL Overall)1786911854.12343340.0
 
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.