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

127 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
streekers1319580(None) 
streakers13218131streakers
streeker12206641streeker_
reekers113613142__reekers
screeners1136732screeners
seekers113712332s__eekers
shriekers16224422shriekers
sleekers12377992s_leekers
steepers103011372st_eepers
steerers82511352st_eerers
streaker12229482streaker_
streamers11228072streamers
streeked13246152streeke_d
streeks11378712streek__s
strewers11409062str_ewers
strikers123611292str_ikers
strokers123910902str_okers
trekkers1133802_trekkers
breakers143810973_breakers
breeders11368893_breeders
careeners1138543careeners
careerers1137243careerers
creepers12318633_creepers
freezers20307173_freezers
greeters92610113_greeters
phreakers1834673phreakers
preeners102712813_preeners
reefers103312593__reefers
reeker103715593__reeker_
reelers73520273__reelers
screamers13236263screamers
screechers17143683screechers
screener1037573screener_
screwers13358063scr_ewers
seeders83017113s__eeders
seeker103615363s__eeker_
seemers93814333s__eemers
sheeters113111863s_heeters
shredders1463713shredders
shrieker15265653shrieker_
shrinkers16205383shrinkers
skeeters12298963s_keeters
sleekens12274873s_leekens
sleeker11339823s_leeker_
sleepers103110113s_leepers
sneakers12308643s_neakers
sneerers8309803s_neerers
sneezers17246143s_neezers
sorcerers1145323sorcerers
speakers14299453s_peakers
speeders11339313s_peeders
spreaders1236503spreaders
squeakers2284113squeakers
squeezers2742553squeezers
stackers143413563st_ackers
stalkers12369853st_alkers
starkers123712393st_arkers
stealers83412213st_ealers
steamers103410873st_eamers
steeked124010473st_eeke_d
steeks103613703st_eek__s
steepens10277113st_eepens
steeper93812773st_eeper_
steerer73113633st_eerer_
steers63820983st__e_ers
steeves103410903st_eeve_s
stemmers12378443st_emmers
steppers12289283st_eppers
stickers142913033st_ickers
stinkers123111133st_inkers
stockers143411073st_ockers
stokers114515183st__okers
stookers12449793st_ookers
strafers11379913str_afers
strainers9510383strainers
strakes114218073str_ake_s
stranders10389933stranders
strangers104112163strangers
strappers1346743strappers
strayers113510143str_ayers
streaked13228453streake_d
streakier1334843streakier_
streaks114411273streak__s
streamer10239513streamer_
streek104111413streek___
streeking14217453streeking
streeled9267873streele_d
streels73811343str_e_els
streetcars1252213streetcars
streets73312613str_e_ets
stresses81112493stresse_s
stressors955793stressors
stretchers1545173stretchers
streusels942933streusels
strewer104310413str_ewer_
striders94412123str_iders
striker113714173str_iker_
strikes114719093str_ike_s
stringers104210643stringers
stripers103911593str_ipers
strippers1355773strippers
strivers113911843str_ivers
stroker114113523str_oker_
strokes114316323str_oke_s
strollers937553strollers
stroppers1356713stroppers
stroyers11388923str_oyers
strummers1333693strummers
strutters955693strutters
sunseekers1442213sunseekers
sweepers13348163s_weepers
teemers95012903_t_eemers
teeners74415453_t_eeners
teeters74018303_t_eeters
trackers143512853_trackers
treaders93311843_treaders
treaters83615843_treaters
treeless839283_treeless
trekker1034733_trekker_
trickers143812813_trickers
truckers14279013_truckers
tweeners11306243_tweeners
tweeters11287143_tweeters
tweezers20254383_tweezers
unreelers9154743unreelers
wreakers15328423_wreakers
wreckers17315973_wreckers

Search took 8 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.420425454.8
2DLD Change Limit1486411277.11020905.9
3Display Results1271270.0632015.9
 (SQL Overall)1786911277.59323533.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.