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

138 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
ousters7412277(None) 
busters94724121busters
dusters84918351dusters
jousters153210401jousters
justers143815721justers
lusters73921431lusters
musters94522491musters
ouster64223731ouster_
outers64230161ou_ters
oysters103411681oysters
rousters84315651rousters
asters65631602_asters
austere7312992austere
basters94930302basters
bisters93922602bisters
blusters104413882blusters
boasters103915652boasters
bolsters103712442bolsters
boosters104013432boosters
bunters94717112bunters
bursters1038982bursters
bushers124018802bushers
buskers133414082buskers
buster84726492buster_
bustiers103810042bustiers
bustlers104210612bustlers
butters94521712butters
casters94729892casters
clusters102912392clusters
coasters104317302coasters
costers94128302costers
coulters103614302coulters
counters103320182counters
courters103015362courters
couters93827282cou_ters
cussers94213392cussers
cutters94218952cutters
doubters11257372doubters
dousers84817272dous_ers
duster74919722duster_
easters75125682easters
esters64627732_esters
festers104121392festers
flusters113811492flusters
fosters104220092fosters
fussers104210812fussers
gasters85624282gasters
gushers113512502gushers
gutters83715502gutters
hoisters113513472hoisters
holsters113211932holsters
housers104717812hous_ers
hunters103915722hunters
hurters103413632hurters
huskers143510032huskers
hustlers11349202hustlers
jesters144118192jesters
jouster143311042jouster_
juster134617012juster_
lasters75627692lasters
listers74026522listers
lobsters10268732lobsters
luster64023672luster_
lustres73013232lustres
masters94628922masters
misters93927502misters
mobsters12359052mobsters
monsters103314532monsters
moulters103510772moulters
mounters103712492mounters
mousers95216442mous_ers
munsters104010542munsters
musers84719092mus_ers
mushers124016432mushers
mustees94614922mustees
muster84724522muster_
mutters94117132mutters
nesters74422782nesters
nutters74215422nutters
oaters65029782o_aters
oldsters996732oldsters
osiers63412792o_siers
ostlers72911202o_stlers
otters64021512o_tters
ousels64815272ous_els
ousted73720582ouste_d
ousts55225702oust__s
outer55633302ou_ter_
outsees72616432outsees
outsert72819512outsert
outserts8309802outserts
outsets73514922outsets
outsteers936032outsteers
oxters134813272o_xters
oyster94111702oyster_
pasters94531732pasters
pesters93827092pesters
posters93927992posters
poulters103911042poulters
pouters94221862pou_ters
punsters103310582punsters
punters93617032punters
pushers123814502pushers
putters94219182putters
questers17168762questers
quoters16369252quoters
rasters74629022rasters
resters74130402resters
roasters83615912roasters
roisters83615542roisters
roosters83514652roosters
rosters73727532rosters
rousers75220132rous_ers
rouster73517082rouster_
routers74822852rou_ters
roysters113610522roysters
rushers103816102rushers
rustlers8339852rustlers
sisters73721572sisters
souters74422582sou_ters
suiters73618872suiters
tasters74225642tasters
testers74124542testers
toasters83912702toasters
touters74018332tou_ters
trusters83112242trusters
tufters10298342tufters
tuskers113710032tuskers
tussers74313562tussers
ulsters72711982ulsters
users55817572_us_ers
ushers94415532_ushers
utters63817112_utters
wasters104026592wasters
westers105221962westers
xysters17307162xysters
zesters163517292zesters
zosters163015402zosters

Search took 4 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.1401276364.3
2DLD Change Limit1076711383.79628364.3
3Display Results1381380.0463000.0
 (SQL Overall)1786911383.98244874.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.