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

425 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
trappers12371102(None) 
crappers144011021crappers
rappers113618441_rappers
strappers1346731strappers
tappers113416541t_appers
trampers123210371trampers
trapper113912791trapper_
trippers123210151trippers
wrappers15306931wrappers
cappers134419402_cappers
clappers143310832clappers
crapper133913192crapper_
croppers143311482croppers
cruppers14317312cruppers
drapers105313352dra_pers
drippers13327932drippers
droppers13318592droppers
entrappers1444182entrappers
flappers15388382flappers
frappes14328382frappe_s
grapplers14274302grapplers
graspers11338392graspers
grippers13358122grippers
knappers16315642knappers
lappers113717462_lappers
mappers133313772_mappers
nappers114214862_nappers
rapers84327182_ra_pers
rapiers95012872_rapiers
rappees113611452_rappees
rappels11448802_rappels
rapper104621572_rapper_
raspers94415912_raspers
rippers114115022_rippers
sappers113518892_sappers
scrappers1545842scrappers
slappers123710932slappers
snappers123510162snappers
strapper1258082strapper_
strippers1355752strippers
stroppers1356702stroppers
swappers15358072swappers
tampers113516742t_ampers
tapers84025812t_a_pers
tapper104419612t_apper_
tappets113610012t_appets
tarpapers1344272tarpapers
tippers113414342t_ippers
toppers113914602t_oppers
tracers94917832tra_cers
trackers143512842trackers
traders84316942tra_ders
trailers82912912trailers
trainers83114632trainers
tramper113812152tramper_
tramplers13305872tramplers
trapes85024462tra_pe_s
trappean1244392trappean
trapped124512212trappe_d
trappous1246012trappous
trashers113013622trashers
trawlers113310192trawlers
tripper113711922tripper_
trippets12357422trippets
troopers10289422troopers
troupers10359422troupers
whappers18276742whappers
wrapper14368332wrapper_
yappers144012252_yappers
zappers203911632_zappers
adapters1136103adapters
apers76629133__a_pers
appears11308953__appears
appels104312793__appels
aspers86220313__aspers
boppers133911923_boppers
bracers114616703bra_cers
braggers12327903braggers
braiders114110573braiders
branders114313093branders
branners104010923branners
brasiers103710513brasiers
bravers124715523bra_vers
brawlers13408643brawlers
brayers124511903bra_yers
brazers184513943bra_zers
braziers19397193braziers
campers134220283_campers
capers105428133_ca_pers
capper124421983_capper_
carpers114521253_carpers
catnappers1682763catnappers
champers173311613champers
chapters154012113chapters
chippers173510873chippers
choppers174110453choppers
clampers143211883clampers
clapper134011863clapper_
claspers124410913claspers
clippers14368833clippers
coappears1542943coappears
coppers133519753_coppers
crabbers14358743crabbers
crackers164111723crackers
cradlers11309183cradlers
crafters13419943crafters
crammers14369343crammers
crapes104727693cra_pe_s
crapped143912623crappe_d
crappier14288133crappier_
crappies142911153crappies
crashers134013223crashers
craters95021883cra_ters
cravers124416543cra_vers
crawlers13309003crawlers
creepers12318623creepers
crimpers14318933crimpers
cripplers15314993cripplers
crispers12309433crispers
cropper133312963cropper_
crupper13338563crupper_
cuppers133712193_cuppers
dampers123915693_dampers
dapper114016633_dapper_
diapers104713893dia_pers
didappers1543163didappers
dippers123615173_dippers
drafters12338523drafters
draggers11357393draggers
drainers92811253drainers
draper94315693dra_per_
drapery13387943dra_pery
drapes95419653dra_pe_s
drawers113610073dra_wers
drawlers12307313drawlers
dripper12349223dripper_
dropper12329873dropper_
entrapper1344853entrapper_
erasers74413943era_sers
flapper14359203flapper_
flippers15337993flippers
floppers15337463floppers
framers125113823fra_mers
frankers15348353frankers
frappe13286953frappe__
frapped15318853frappe_d
fraters103517203fra_ters
frippery1832953frippery
gapers94520463_ga_pers
gaspers105014133_gaspers
gawpers13448313_gawpers
gippers123212073_gippers
grabbers13337883grabbers
graders94715993gra_ders
grafters12409183grafters
grainers93012073grainers
grangers103011973grangers
granters93614133granters
grapery13457953gra_pery
grapes95123123gra_pe_s
grapier103712603grapier_
grapnels1134393grapnels
grappas12357103grapp_as
grappler13336193grappler_
grapples13348123grapples
grasper10389783grasper_
graters85419733gra_ters
graupels1133103graupels
gravers114515263gra_vers
grazers175112443gra_zers
graziers18387123graziers
gripers104011463gr_ipers
gripper124410713gripper_
grippes124810373grippe_s
gropers104813853gr_opers
groupers11358633groupers
gyppers15235503_gyppers
hampers143616943_hampers
happens14359173_happens
harpers124916203_harpers
heapers123616673hea_pers
hoppers143115143_hoppers
japers154616173_ja_pers
jaspers164310463_jaspers
kippers153211423_kippers
knapper15387153knapper_
kraters114212333kra_ters
lampers113817333_lampers
lapper104319953_lapper_
lappets11329123_lappets
lapsers93911053_lapsers
leapers93716663lea_pers
lippers113416433_lippers
loppers113014103_loppers
mapper124516093_mapper_
moppers133412453_moppers
napper103718283_napper_
nappes104515623_nappe_s
nippers113012613_nippers
pampers133615933_pampers
papers105125323_pa_pers
paupers114311073_paupers
peppers103311443_peppers
petnappers1342433petnappers
poppers103414863_poppers
praisers103410833praisers
prancers123210333prancers
praters94921643pra_ters
prawners1346003prawners
prayers124212853pra_yers
propers113619033pr_opers
prospers123012253prospers
quippers2184803quippers
racers84725433_ra_cers
rackers134320453_rackers
rafters103715633_rafters
raiders84615143_raiders
railers74420663_railers
raisers73617393_raisers
rakers104123573_ra_kers
rammers113715043_rammers
rangers83621043_rangers
rankers113217463_rankers
ranters73323643_ranters
raper74932753_ra_per_
rapes75740723_ra_pe_s
raphes115117453_raphe_s
rapier84019993_rapier_
rapped114122683_rappe_d
rappee103618673_rappe_e
rappel104211953_rappe_l
rappen103512713_rappe_n
rapport11311223_rapport
rapports1245963_rapports
raptors94213353_raptors
rasers64526783_ra_sers
rashers104020903_rashers
rasper83917323_rasper_
rasters74629023_rasters
raters63936573_ra_ters
ratters74422473_ratters
ravers94628183_ra_vers
razers154919613_ra_zers
reapers93520453_reapers
reappears1342853reappears
repapers1258833_repapers
ripper103518653_ripper_
ripplers12337113_ripplers
rompers113412243_rompers
ropers84325903_r_opers
sapper103822353_sapper_
scalpers123710863scalpers
scampers143611033scampers
scarpers124712513scarpers
scaupers12378173scaupers
scrapers125510513scra_pers
scrapper1466953scrapper_
scuppers1446533scuppers
shapers124016893sha_pers
sharpers133810943sharpers
shippers153012303shippers
shoppers153010753shoppers
sippers113117743_sippers
skippers16318193skippers
slapper113512463slapper_
slippers123711223slippers
snapper113512073snapper_
snippers12299713snippers
soapers93715923soa_pers
stampers124211593stampers
staplers103111183staplers
steppers12289273steppers
stoppers123910573stoppers
strafers11379903stra_fers
strainers9510373strainers
stranders10389923stranders
strangers104112153strangers
strapless1135783strapless
strapped1357813strappe_d
strappier1345123strappier_
strayers113510133stra_yers
stripers103911583str_ipers
stripper1247113stripper_
stropper1247753stropper_
suppers113314693_suppers
swampers15317473swampers
swapper14359703swapper_
tabers84621573t_a_bers
tackers134319623t_ackers
taggers93514193t_aggers
tailers73720183t_ailers
takers103923743t_a_kers
talers64628143t_a_lers
talkers113513213t_alkers
tamers84224033t_a_mers
tamper104618513t_amper_
tankers113416913t_ankers
tanners74018393t_anners
taper74829773t_a_per_
taperers10269773t_aperers
tapes75838603t_a_pe_s
tapirs84113173t_a_pirs
tapped113820053t_appe_d
tappet103820113t_appe_t
tapsters10318803t_apsters
tarpaper1244603tarpaper_
tarriers83411713tarriers
tarsiers8298533tarsiers
tasters74225643t_asters
taters64932193t_a_ters
tatters74520483t_atters
taupes8212673t_aupe_s
tawers94118603t_a_wers
taxers134015283t_a_xers
teachers133212393teachers
tearers75218233tea_rers
teasers75317243tea_sers
telphers1335473telphers
tempers113513013t_empers
tempters12257293tempters
thalers106212263tha_lers
thankers15297833thankers
thawers13428483tha_wers
thrashers1565293thrashers
threapers1444773threapers
thumpers15365713thumpers
tipper103918413t_ipper_
tippets11339373t_ippets
tipplers12336353tipplers
toasters83912703toasters
topers85025323t__opers
topper103817603t_opper_
tracer84820233tra_cer_
tracery12399793tra_cery
traces85329933tra_ce_s
tracheas13410273tracheas
tracker133515173tracker_
tractors10312553tractors
trader75218753tra_der_
trades75724493tra_de_s
traducers1243713traducers
trailer73015393trailer_
trainees82712063trainees
trainer73316793trainer_
traipses1036873traipses
traitors8310773traitors
tramcars1245223tramcars
tramels93812493tra_mels
tramless1037503tramless
trammels12295413trammels
tramped124312433trampe_d
trampier12318233trampier_
trampler12278003trampler_
tramples122610203tramples
tramps105114453tramp__s
trances93919643trance_s
transfers1238043transfers
trapans92812463tra_pans
trapdoors1243143trapdoors
trapeses1039153trapeses
trapeze1836243tra_peze
trapezes1936543trapezes
trapnest10310923trapnest
trapnests1144433trapnests
trapping132911393trapping
trappings14265753trappings
trappose1245813trappose
traps75727483tra_p__s
trasher104416123trasher_
trashes104119253trashe_s
trasses74819323trasse_s
travelers12266773travelers
travels104711293tra_vels
traverse1136213tra_verse
traves94222743tra_ve_s
trawler104011903trawler_
trawleys14284383trawleys
treaders93311833treaders
treadlers1045883treadlers
treaters83615823treaters
trekkers1133803trekkers
trickers143812813trickers
triers64321523tr__iers
triflers113110213triflers
triggers10257843triggers
trillers83613483trillers
trimers94615143tr_imers
trimmers12288913trimmers
tripes85324873tr_ipe_s
triples94616873triple_s
triplets103510263triplets
tripped123911693trippe_d
trippet113714113trippe_t
trippier1246623trippier_
troffers14125423troffers
trollers83211203trollers
trompes114111623trompe_s
trooper94210353trooper_
tropes84824353tr_ope_s
trotters83310233trotters
trouper93811413trouper_
troupes94112843troupe_s
trousers83910623trousers
trovers103713313tr_overs
trowsers11427983trowsers
truckers14279003truckers
trudgers10256853trudgers
trumpery1533613trumpery
trumpets12315573trumpets
trussers8348263trussers
trusters83112243trusters
trysters11298363trysters
twangers12226063twangers
uppers102912283__uppers
vampers143111623_vampers
warpers123413583_warpers
whapper17348273whapper_
whippers18329033whippers
whoppers18297533whoppers
wrapped15338023wrappe_d
yapper133714513_yapper_
yaupers12337663_yaupers
yawpers15346853_yawpers
zapper193414023_zapper_
zippers203310373_zippers

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.1561145455.1
2DLD Change Limit1461624257.56319325.9
3Display Results4254250.1562724.4
 (SQL Overall)1786914257.87522690.9
 
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.