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 “strollers” 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
strollers93754(None) 
stroller848171stroller_
trollers83211211_trollers
carollers1137702carollers
enrollers976172enrollers
patrollers1244812patrollers
rerollers9207122rerollers
rollers73117472__rollers
stollens835292st_ollens
strokers123910902stro_kers
strolled937812strolle_d
strolls739182stroll__s
stroppers1356712stroppers
stroyers11388922stro_yers
tollers73217462_t_ollers
trillers83613492_trillers
troller73913172_troller_
trolleys11315692_trolleys
astrologers1252973astrologers
broilers103210093_broilers
carolers103314173caro_lers
caroller1039203caroller_
controllers1344783controllers
crullers1047303_crullers
drillers9429723_drillers
droller84110283_droller_
drollery12314793_drollery
enrollees974323enrollees
enroller867183enroller_
extollers1663843extollers
frillers11349873_frillers
girolles935523girolle_s
grillers93810813_grillers
growlers12327093_growlers
hollers103818233__hollers
knollers12255143_knollers
krullers1234133_krullers
logrollers1142223logrollers
lollers72713793__lollers
patroller1145743patroller_
pollers93420023__pollers
prowlers13328933_prowlers
reroller8258753reroller_
rolfers104011813__rolfers
roller63919793__roller_
schillers14285663schillers
scolders11288993s_colders
scowlers13257373s_cowlers
scrawlers1434753scrawlers
scrolled1137053scrolle_d
scrolls938063scroll__s
scullers103510483s_cullers
sellers73721313s__ellers
shellers112812573s_hellers
shriller1136823shriller_
sillers73822103s__illers
smellers10329763s_mellers
smolders11287193s_molders
solders83517773s__olders
solvers104414253s__olvers
spallers102910733s_pallers
spellers102812753s_pellers
spillers103311703s_pillers
spoilers10238633s_poilers
spoolers10349363s_poolers
sprawlers1433903sprawlers
squallers1834683squallers
stablers103611153st_ablers
stalkers12369853st_alkers
staplers103111203st_aplers
startlers9236743startlers
stealers83412203st_ealers
steamrollers1451473steamrollers
sticklers15227393sticklers
stiflers11238833st_iflers
stiller73414293st_iller_
stipplers1334453stipplers
stockers143411073st_ockers
stokers114515183st_o_kers
stoles63927673st_o_le_s
stollen747583st_olle_n
stompers123610043st_ompers
stoners74817953st_o_ners
stookers12449793st_ookers
stoolies8311083stoolie_s
stoopers103711303st_oopers
stopers94217373st_o_pers
stoppers123910593st_oppers
storers75018683st_o_rers
stovers103713733st_o_vers
straddlers12203823straddlers
strafers11379913str_afers
stragglers12305253stragglers
strainers9510383strainers
stranders10389933stranders
strangers104112163strangers
stranglers11396823stranglers
strapless1135793strapless
strappers1346743strappers
strayers113510143str_ayers
streakers13218133streakers
streamers11228073streamers
streekers13195803streekers
strewers11409063str_ewers
striders94412123str_iders
strikers123611293str_ikers
stringers104210643stringers
stripers103911593str_ipers
strippers1355773strippers
strivers113911843str_ivers
strobes93813263stro_be_s
strobiles1146953strobile_s
stroker114113523stro_ker_
strokes114316323stro_ke_s
stroll6311603stroll___
strolling10238793strolling
stronger9349693stronger_
strophes13310603strophe_s
stropper1247763stropper_
stroyer103510783stro_yer_
strugglers12273063strugglers
strummers1333693strummers
strutters955693strutters
stumblers1334383stumblers
stylers10359353st__ylers
swillers11299113s_willers
tellers73717593_t_ellers
thrillers1244473thrillers
tillers73418743_t_illers
toilers74116263_t_oilers
toller63819443_t_oller_
toolers74416503_t_oolers
toolless836343_toolless
tootlers8289503_tootlers
trailers82912923_trailers
trawlers113310203_trawlers
triflers113110213_triflers
triller74215893_triller_
troffers14125433_troffers
trolled84312263_trolle_d
trolley10328753_trolle_y
trollies8310233_trollies
trollops1044813_trollops
trolls64613943_troll__s
troopers10289443_troopers
trotters83310243_trotters
troublers1135003_troublers
troupers10359443_troupers
trousers83910633_trousers
trovers103713323_tro_vers
trowelers12105263_trowelers
trowellers1343663_trowellers
trowsers11428003_trowsers

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.733243780.4
2DLD Change Limit1486411537.79619066.3
3Display Results1531530.0632428.6
 (SQL Overall)1786911538.59220797.4
 
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.