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

342 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
troopers1028944(None) 
trooper94210361trooper_
troupers10359441troupers
bloopers12397372bloopers
brooders112610242brooders
coopers114019482_coopers
crooners103911392crooners
croppers143311482croppers
droppers13318602droppers
groomers11388482groomers
groovers12337122groovers
gropers104813852gr_opers
groupers11358642groupers
hoopers123616482_hoopers
loopers93914032_loopers
proofers13118362proofers
propers113619032pr_opers
prospers123012262prospers
rompers113412242_rompers
roofers105013902_roofers
roomers95416412_roomers
roosers74217872_roosers
rooters74522932_rooters
ropers84325902_r_opers
scoopers124210192scoopers
snoopers10319842snoopers
stoopers103711302stoopers
stroppers1356712stroppers
swoopers13317522swoopers
toolers74416502t_oolers
tooters73818772t_ooters
topers85025322t__opers
toppers113914602t_oppers
trampers123210392trampers
trappers123711042trappers
trippers123210162trippers
troffers14125432troffers
trollers83211212trollers
trompes114111622trompe_s
trooped104010722troope_d
troops85712782troop__s
tropes84824352tr_ope_s
trotters83310242trotters
trouper93811432trouper_
troupes94112852troupe_s
trousers83910632trousers
trovers103713322tr_overs
trowsers11428002trowsers
whoopers16286262whoopers
armorers10288973armorers
arousers84810983arousers
bloomers12348823bloomers
blooper11358533blooper_
boogers104514633_boogers
bookers134016613_bookers
boomers114115913_boomers
boozers183912443_boozers
boppers133911923_boppers
broiders114211193broiders
broilers103210093broilers
brokers133111913br_okers
bronzers19296983bronzers
brooder103811623brooder_
brothers133410833brothers
browsers13449203browsers
chompers17369593chompers
choosers134810873choosers
choppers174110463choppers
cooers84324563_coo_ers
cookers134619463_cookers
coolers93522493_coolers
cooper104221123_cooper_
coopery143910273_coopery
cooters94525723_cooters
copers104629843__copers
coppers133519753_coppers
coroners104016223coroners
crappers144011023crappers
creepers12318633creepers
crimpers14318933crimpers
crispers12309433crispers
croakers14288523croakers
crofters13358903crofters
crooker134111093crooker_
crookery17415993crookery
crooner93714043crooner_
cropper133312963cropper_
crosiers103312063crosiers
crossers103912703crossers
croupes114613103croupe_s
croupiers1334653croupiers
crowders14398813crowders
crowers124614903cr_owers
crowners133710753crowners
crozers184111083cr_ozers
croziers19287003croziers
cruppers14317323cruppers
doozers17419293_doozers
dopers95522483__dopers
dorpers104113173_dorpers
drapers105313353dr_apers
drippers13327943drippers
droners84114383dr_oners
drooped11368433droope_d
droopier1145573droopier_
droops95110963droop__s
dropper12329873dropper_
drovers115212643dr_overs
drowners12428273drowners
elopers95112943_elopers
flooders12257833flooders
floorers11227573floorers
floppers15337463floppers
footers104618333_footers
frothers14279813frothers
frowners14377933frowners
goobers10219623_goobers
graspers11338403graspers
gripers104011463gr_ipers
grippers13358133grippers
groaners9248503groaners
grocers103511253gr_ocers
groomer10399873groomer_
groover11358543groover_
grooves11368803groove_s
groper94517253gr_oper_
gropes95220403gr_ope_s
grossers94410973grossers
grouper104210093grouper_
grousers93810733grousers
grouters95910083grouters
growers113612723gr_owers
growlers12327093growlers
hoofers134513323_hoofers
hookers144916513_hookers
hooper114518313_hooper_
hooters104520473_hooters
hoovers134312703_hoovers
hopers114222973__hopers
hoppers143115143_hoppers
ironers74813553ir_oners
lookers114014073_lookers
looper83817113_looper_
looters74419163_looters
lopers84424143__lopers
loppers113014103_loppers
mooners94015343_mooners
mooters93818623_mooters
mopers104220373__mopers
moppers133412463_moppers
noosers74913923_noosers
poolers94217423_poolers
poppers103414863_poppers
probers113514583pr_obers
prodders1237463prodders
proffers16126593proffers
proggers12258163proggers
promoters13310093promoters
prompters1537553prompters
proofer12149103proofer_
propels113412843pr_opels
proper104319953pr_oper_
proposers13228523proposers
prosers94219643pr_osers
prosper114012193prosper_
provers123817793pr_overs
provokers1894203provokers
prowlers13328933prowlers
rapers84327183_r_apers
rappers113618443_rappers
raspers94415923_raspers
reapers93520453_reapers
reopens939373_reopens
rioters73615513_rioters
rippers114115033_rippers
roamers93713463_roamers
roarers73812743_roarers
robbers112814163_robbers
rockers133916553_rockers
rogers74517913_r_ogers
rolfers104011813_rolfers
rollers73117473_rollers
romper104213683_romper_
roofer94415283_roofer_
rookery14398313_rookery
roomer84718633_roomer_
rooser63921883_rooser_
rooses65526233_roose_s
roosters83514663_roosters
rooter64926033_rooter_
roper75431913_r_oper_
ropery114313873_r_opery
ropes75940063_r_ope_s
rosters73727543_rosters
rotters74421393_rotters
rousers75220143_rousers
routers74822873_routers
rovers95423523_r_overs
rowers94924573_r_owers
rozzers1535633_rozzers
scooper113812033scooper_
scooters103511033scooters
shooters112811583shooters
shoppers153010763shoppers
slopers94213093_slopers
snookers12398653snookers
snooper93511533snooper_
snoozers17296943snoozers
soapers93715923_soapers
sooners73916643_sooners
spoofers13307323spoofers
spoolers10349363spoolers
stompers123610043stompers
stookers12449793stookers
stooper93813193stooper_
stopers94217373_stopers
stoppers123910593stoppers
strappers1346743strappers
stripers103911593str_ipers
strippers1355773strippers
strokers123910903str_okers
strollers937553strollers
stropper1247763stropper_
stroyers11388923str_oyers
swooners11336863swooners
swooper12389173swooper_
taborers10268333taborers
tampers113516743t_ampers
tapers84025813t__apers
tappers113416543t_appers
tarpapers1344273tarpapers
tempers113513013t_empers
tenoners858713tenoners
thorpes125010353thorpe_s
threapers1444773threapers
throbbers1643173throbbers
throwers14106033throwers
thumpers15365713thumpers
tippers113414353t_ippers
tochers123413093t_ochers
toilers74116263t_oilers
tokers104818893t__okers
tollers73217463t_ollers
toners64128003t__oners
tongers84116013t_ongers
tonners73816403t_onners
tooler63818613t_ooler_
tooter64420803t_ooter_
tootlers8289503tootlers
topees85519703t__opees
toper75231023t__oper_
topes76941763t__ope_s
topper103817603t_opper_
torpors939383t_orpors
torquers17204303torquers
tossers74713503t_ossers
toters65026363t__oters
totters74618733t_otters
toupees938513t_oupees
tourers73512743t_ourers
touters74018353t_outers
towers94423673t__owers
toyers95516333t__oyers
tracers94917843tr_acers
trackers143512853trackers
traders84316953tr_aders
trailers82912923trailers
trainers83114643trainers
tramper113812163tramper_
tramplers13305883tramplers
trapes85024463tr_ape_s
trapper113912803trapper_
trashers113013643trashers
trawlers113310203trawlers
treaders93311843treaders
treaters83615843treaters
trekkers1133803trekkers
trickers143812813trickers
triers64321523tr__iers
triflers113110213triflers
triggers10257843triggers
trillers83613493trillers
trimers94615143tr_imers
trimmers12288913trimmers
triodes84012503triode_s
triolets83410143triolets
trioses75015653triose_s
tripes85324873tr_ipe_s
tripper113711923tripper_
trippets12357423trippets
trocars959043tr_ocars
trochars1377853trochars
trochees132510183trochees
troches123715343troche_s
troffer13125863troffer_
trokes104019263tr_oke_s
troller73913173troller_
trolleys11315693trolleys
trommels12254333trommels
trompe105611263trompe__
tromped124210293trompe_d
tromps104911703tromp__s
trones65629283tr_one_s
troop76417533troop___
troopial1045483troopial
troopials1143833troopials
trooping112710283trooping
trope75725803tr_ope__
tropics113610653tr_opics
tropins93116313tr_opins
trotter73312253trotter_
troublers1135003troublers
trouncers1134803trouncers
troupe84812433troupe__
trouped103910983troupe_d
trouser73812473trouser_
trouvere1144073trouvere
trouveres1243773trouveres
trouveurs1241643trouveurs
trover95014663tr_over_
troves94719113tr_ove_s
trowelers12105263trowelers
trowels10358363tr_owels
truckers14279013truckers
trudgers10256863trudgers
trumpery1533613trumpery
trumpets12315573trumpets
trussers8348283trussers
trusters83112263trusters
trysters11298373trysters
turnovers1243283turnovers
tutoyers1133303tutoyers
twofers1364053t_wofers
uprooters1164253uprooters
whoopees16294823whoopees
whooper15297153whooper_
whoppers18297533whoppers
wooers93712443_woo_ers
woofers133810583_woofers
woolers104214023_woolers
wrappers15306933wrappers
wrongers12327773wrongers

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 Filter1786911461620.423422437.4
2DLD Change Limit1461623426.56022280.8
3Display Results3423420.1262714.3
 (SQL Overall)1786913427.10925135.9
 
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.