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

153 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
strutters95570(None) 
strutter846501strutter_
stutters83210471st_utters
scutters103311022s_cutters
shutters113611352s_hutters
splutters11286272splutters
sputters104012872s_putters
strummers1333692strummers
strutted946342strutte_d
stutter72911462st_utter_
trotters83310252_trotters
trusters83112262_trusters
abutters1056993_abutters
bruiters10329143_bruiters
butters94521723__butters
clutters103210353_clutters
critters103511333_critters
cutters94218963__cutters
druthers1275793_druthers
flutters114010823_flutters
fretters113410303_fretters
fritters113810783_fritters
fruiters11328183_fruiters
garotters1055043garotters
gritters94210633_gritters
grunters9359043_grunters
gutters83715513__gutters
inputters1143443inputters
mutters94117143__mutters
nutters74215433__nutters
putters94219193__putters
ratters74422473__ratters
rebutters1195093rebutters
reutters8138573_reutters
ritters74020623__ritters
rotters74421393__rotters
saluters8319863salu_ters
saturaters1045563saturaters
saunters82911753s_aunters
scatters103612753s_catters
scouters103411323scou_ters
scouthers1445993scouthers
scripters13116683scripters
scrubbers1543373scrubbers
scutter93512173s_cutter_
setters73822063s__etters
shatters113313913s_hatters
shouters113510623shou_ters
shunters113210753s_hunters
shutter103712143s_hutter_
shuttlers1254123s_huttlers
sitters74221553s__itters
skitters12349553s_kitters
slitters84014133s_litters
slotters84012403s_lotters
smatters104011713s_matters
sorters74221133sor__ters
souters74422603s_ou_ters
southers114214453s_outhers
spatters103914703s_patters
spitters104113383s_pitters
splatters11327543splatters
splitters11307323splitters
splutter10357443splutter_
spluttery14293623spluttery
spotters104313383s_potters
spouters104011163spou_ters
sprinters11329373sprinters
spritzers2043903spritzers
spurters103311703s_purters
sputter94014053s_putter_
sputtery13366473s_puttery
squatters1834953squatters
starters83714783st_arters
startlers9236743startlers
staters73922343st__aters
statutes8368893statute_s
stinters83312763st_inters
stoutens8255273stou_tens
stouter74012053stou_ter_
stoutness945863stoutness
strafers11379913str_afers
strainers9510403strainers
straitens946243straitens
straiter8311783straiter_
stranders10389943stranders
strangers104112173strangers
strappers1346743strappers
strayers113510143str_ayers
streakers13218143streakers
streamers11228083streamers
streekers13195813streekers
stretchers1545173stretchers
strettas846433strett_as
strette7310763strette__
strettos847133strett_os
strewers11409073str_ewers
striates83417093striate_s
stricter1039423stricter_
striders94412123str_iders
strikers123611293str_ikers
stringers104210653stringers
stripers103911593str_ipers
strippers1355773strippers
strivers113911843str_ivers
strokers123910913str_okers
strollers937563strollers
stroppers1356723stroppers
stroyers11388933str_oyers
structure1145243structure
structures1245453structures
strudels934123stru_dels
strugglers12273063strugglers
strummer1234783strummer_
strumpets1362893strumpets
strunted957243strunte_d
strunts7429543strunt__s
struts65616803stru_t__s
strutting1037003strutting
studiers9236623st_udiers
stuffers14277383st_uffers
stuivers11406673st_uivers
stumpers12318313st_umpers
stunners8277923st_unners
stuttered10145763st_uttered
stutterer9164913st_utterer
stutterers10164303st_utterers
suiters73618883s__uiters
sutlers73116973s__utlers
suttees74114063s__uttees
swatters113911793s_watters
swotters11448483s_wotters
syrettes1136963syrette_s
tatters74520483_t_atters
taunters8259273_taunters
tetters74320473_t_etters
thrusters1245333thrusters
titters74219623_t_itters
totters74618733_t_otters
touters74018353_tou_ters
treaters83615853_treaters
trotter73312253_trotter_
truckers14279013_truckers
trudgers10256863_trudgers
trussers8348283_trussers
trustees8339323_trustees
truster73114313_truster_
trustors8268913_trustors
trysters11298373_trysters
tufters10298353_t_ufters
turtlers8258203_turtlers
twitters11296773_twitters
utters63817123___utters

Search took 9 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.440406115.9
2DLD Change Limit1486411537.65619415.0
3Display Results1531530.0632428.6
 (SQL Overall)1786911538.15921901.1
 
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.