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

268 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
trampier1231824(None) 
crampier14288901crampier
tramper113812161tramp_er
trampler12278011trampler
campier133313272_campier
crappier14288132crappier
crimpier14287322crimpier
frumpier1534172frumpier
grapier103712602gra_pier
grumpier1334802grumpier
rammier112811022_rammier
rapier84019992_ra_pier
raspier93110642_raspier
strappier1345132strappier
swampier1544592swampier
tamper104618512t_amp_er
tramped124312432tramp_ed
trampers123210392tramp_ers
trampiest13227892trampiest
tramping132711272tramping
trampish1535652trampish
trample11299702trample_
trampled13247902trampled
tramplers13305882tramplers
tramples122610202tramples
trapper113912802tra_pper
trashier113210102trashier
trippier1246622trippier
vampier14308232_vampier
ampler104313303__ampler
barmier114313043barm_ier
beamier113411943beam_ier
braggier12136453braggier
brainier102510233brainier
brakier133812363bra_kier
bramblier1543503bramblier
brannier10218933brannier
brashier13389933brashier
brasier94516753bra_sier
brassier103310533brassier
brattier1047663brattier
brawlier13267043brawlier
brawnier13216723brawnier
brazier183911473bra_zier
bumpier13359203_bumpier
camper124722213_camp_er
champer163813413champ_er
clammier1435843clammier
clamper134012993clamp_er
clumpier1435583clumpier
crabbier14326803crabbier
craftier1376193craftier
craggier12116063craggier
crammer134010963cram_mer
cramped144712183cramp_ed
crampiest15268613crampiest
cramping153411853cramping
crampit1338863crampi_t
crampits1436273crampits
crankier14339163crankier
crapper133913193cra_pper
crappie13298983crappie_
crappies142911153crappies
crawlier13216873crawlier
crazier183610743cra_zier
creamier12319063cream_ier
creepier1236253creepier
crepier1139743cr_epier
crimper136510423crimp_er
crispier12297253crispier
croupier1246883croupier
crumbier1456363crumbier
crummier1435603crummier
crumplier1543783crumplier
damper114117753_damp_er
draffier1574323draffier
draftier1285263draftier
draggier11135773draggier
draper94315693dra_p_er
drawlier12225253drawlier
dreamier11287293dream_ier
drippier1385043drippier
droopier1145573droopier
drumlier1134523drumlier
dumpier12409653_dumpier
flamier123112143flam_ier
flappier1544293flappier
foamier12339003foam_ier
framer114817443fram__er
gambier124711973_gambier
gamier93617933_gam_ier
gammier123711193_gammier
gappier12369843_gappier
gimpier12247943_gimpier
glumpier1334873glumpier
grabbier13316653grabbier
grainier9218903grainier
grappler13336193grappler
grasper10389793grasp_er
grassier9349283grassier
grazier173611133gra_zier
grimier103210433grim_ier
gripier103210323gr_ipier
grippier1355203grippier
hammier143510653_hammier
hamper134518653_hamp_er
happier143312033_happier
hempier14319003_hempier
humpier143110723_humpier
jammier18408023_jammier
jumpier18317943_jumpier
lambier113611643_lambier
loamier9349163loam_ier
lumpier113410143_lumpier
nappier114411173_nappier
orangier947713orangier
pamper124316663_pamp_er
pappier103511593_pappier
premier113515633prem_ier
preppier1156643preppier
prompter1437983prompter
racier85120973_ra_cier
rainier71614263_rainier
rallier73816273_rallier
rambler113313263_rambler
ramie75027823_ram_ie_
ramies84630463_ram_ies
rammer103519653_ram_mer
rampager1344453_rampager
ramped114617903_ramp_ed
rampike1536603_rampike
rampikes1635393_rampikes
ramping123316873_ramping
rampion11298583_rampion
randier83618473_randier
rangier83714353_rangier
raper74932753_ra_p_er
rapider1067903_ra_pider
rapiers95012873_ra_piers
rapper104621573_ra_pper
rasper83917333_rasp_er
rattier74015593_rattier
rimier83916273_rim_ier
romper104213683_romp_er
ropier84118803_r_opier
roupier9319493_roupier
rummier11309563_rummier
rumplier1235303_rumplier
sampler113212013_sampler
sappier113613113_sappier
scamper134613163scamp_er
scampies1439323scampies
scrappier1544423scrappier
scrimpier1554243scrimpier
seamier93114633seam_ier
shrimpier1643063shrimpier
skimpier1634293skimpier
snappier1266213snappier
soapier93411713soa_pier
stamper113714403stamp_er
steamier1048303steam_ier
strapper1258093stra_pper
strawier1137493stra_wier
streamier1155763stream_ier
stripier1058863str_ipier
stroppier1364453stroppier
stumpier1255883stumpier
swamper14349313swamp_er
tackier133712523t_ackier
talkier114011843t_alkier
tallier72817213t_allier
tamer75230103t_am__er
tammie104212693t_ammie_
tammies113814683t_ammies
tamped114317043t_amp_ed
tamperer12248893t_amperer
tampers113516743t_amp_ers
tamping122815813t_amping
tampion11298663t_ampion
tangier83013903t_angier
taper74829773t_a_p_er
tapir75917063t_a_pi_r
tapper104419613t_a_pper
tardier859719993t_ardier
tarrier74323173t_arrier
tarsier74119253t_arsier
tartier74123263t_artier
tastier711817093t_astier
tattier74216243t_attier
tawnier10318463t_awnier
tawpie11339143t_awpie_
tawpies12309873t_awpies
teamaker1445113teamaker
teamster1036293teamster
tearier73815613tea_rier
temper103914093t_emp_er
tempter11358213t_empter
thrummier1641793thrummier
thumper14356953thump_er
thymier1534393thym_ier
tippier113210543t_ippier
toastier846893toastier
tracer84820233tra__cer
tracker133515173tra_cker
trader75218763tra__der
traducer1144583traducer
trailer73015393tra_iler
trainer73316793tra_iner
traipse935873traipse_
traipsed1134753traipsed
traipses1036873traipses
tramcar1135593tram_car
tramel84113713tram__el
trameled11309073trameled
tramline10311383tramline
tramlines1139843tramlines
trammed123810713tram_med
trammel11357663tram_mel
trammeler1343223trammeler
tramming13279343tramming
tramp96319773tramp___
trampling1436973trampling
trampoliner1552313trampoliner
tramps105114453tramp__s
trampy13499253tramp__y
trannies8415013trannies
transfer1138433transfer
transpire1148863transpire
trapes85024463tra_p_es
trapped124512213tra_pped
trappers123711043tra_ppers
trapping132911393trapping
trasher104416133tra_sher
traveler11328433traveler
trawler104011903tra_wler
treaclier1144153treaclier
trembler1235363trembler
tremblier1343283tremblier
trendier937913trendier
tressier847963tressier
trickier143010233trickier
trier54328533tr___ier
trimer85717153trim__er
trimeter10310083trimeter
trimmer113610833trim_mer
tripper113711923tr_ipper
trompe105611263tromp_e_
tromped124210293tromp_ed
trompes114111623tromp_es
tromping13319603tromping
trooper94210363troop_er
trouper93811433troup_er
troutier8277153troutier
trumped12439713trump_ed
trumpery1533613trump_ery
trumpet113810723trump_et
trumpeter1343153trumpeter
trumping13308733trumping
trustier8268683trustier
twangier1254243twangier
typier1137333t__ypier
vamper134212653_vamp_er
vampire14296673_vampire
waspier12259053_waspier
wimpier14248053_wimpier
wrapper14368333wra_pper
wrathier1435903wrathier
zappier20458373_zappier

Search took 10 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.843211970.3
2DLD Change Limit1461622688.23617746.7
3Display Results2682680.1062528.3
 (SQL Overall)1786912689.18519454.7
 
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.