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

517 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
trompe10561126(None) 
tromp95815801tromp_
tromped124210291tromped
trompes114111621trompes
tromps104911701tromps
trope75725801tro_pe
troupe84812431troupe
brome94421972brom_e
croupe105114432croupe
grope84821612gro_pe
prompt12313012prompt
romp85926572_romp_
romped114513652_romped
romper104213682_romper
romps94617542_romps
rope65542912_ro_pe
thorpe113610092thorpe
tome67543192t_om_e
tope65946382t_o_pe
tramp96319772tramp_
tramped124312432tramped
tramper113812152tramper
trample11299702trample
tramps105114452tramps
trampy13499252trampy
tripe75425382tr_ipe
troche113112512troche
trode65322852tro_de
troke94821052tro_ke
trommel11315362trommel
trone55131862tro_ne
troop76417532troop_
trooped104010722trooped
trooper94210352trooper
troops85712772troops
trop66833302tro_p_
tropes84824352tro_pes
trouped103910972trouped
trouper93811412trouper
troupes94112842troupes
trove85221922tro_ve
trump95615122trump_
trumped12439712trumped
trumpet113810722trumpet
trumps104611882trumps
anomie83215963anomie
arame75026623aram_e
aroma71220143arom_a
aromas81018613aromas
arose55832083aro_se
arouse65019983arouse
biome94916993biom_e
bombe115519313_bombe
broche133612103broche
brogue94211033brogue
broke116019783bro_ke
bromal10313653bromal
bromate11313553bromate
bromes104719763bromes
bromic122412693bromic
bromid112612893bromid
bromide12269583bromide
bromin102615693bromin
bromine112915243bromine
bromize20238823bromize
bromo95217203brom_o
bromos104213313bromos
bronze173610923bronze
brose75227033bro_se
browse115713853browse
brume95817983brum_e
chomp144815663chomp_
chomped17329773chomped
chomper163810073chomper
chomps155112223chomps
chrome133214813chrom_e
clomp115615703clomp_
clomped14398973clomped
clomps125212233clomps
comae97128423_comae
combe116223543_combe
come87547703_com_e
comp106731253_comp_
comped135919873_comped
compel124412893_compel
compo115318573_compo
comps115526053_comps
compt116328223_compt
comte96125473_comte
coombe124110093coombe
cope86847383_co_pe
coupe96023483_coupe
crambe1239073crambe
cramp115120693cramp_
cramped144712183cramped
cramps125615563cramps
crampy154710993crampy
crape96128443cr_ape
creme94319323crem_e
crepe95520723cr_epe
crime94822693crim_e
crimp115615803crimp_
crimped143910763crimped
crimper136510423crimper
crimple13408693crimple
crimps124613453crimps
crimpy15489393crimpy
cripe95521143cr_ipe
crone75231333cro_ne
crop87628633cro_p_
cropped143812063cropped
cropper133312963cropper
croppie13278793croppie
crops96125233cro_ps
crore74922863cro_re
crosse85216303crosse
croup95616783croup_
croupes114613103croupes
croups104312553croups
croupy13458733croupy
crouse84619363crouse
croute84617273croute
croze164719453cro_ze
crump115616423crump_
crumped144311223crumped
crumpet133711063crumpet
crumple13368363crumple
crumps124514343crumps
dome77240733_dom_e
dope76038893_do_pe
dormie9312623dormie
drape85319633dr_ape
drogue8938333drogue
dromon939363dromon
drone65324983dro_ne
droop85814823droop_
drooped11368433drooped
droops95110963droops
droopy12458243droopy
drop75324403dro_p_
dropped13329283dropped
dropper12329873dropper
drops85719503dro_ps
dropt86924433dro_pt
drove95518063dro_ve
drowse105010553drowse
drupe85012993dr_upe
elope75219343elo_pe
erode64520993ero_de
erose55727273ero_se
forme105225993form_e
formee113919943formee
frame105821803fram_e
frappe13286953frappe
froe75329993fro__e
from96923923from__
fromage1336753fromage
frore86218803fro_re
froze174515653fro_ze
frump126912563frump_
frumps13479783frumps
frumpy16466883frumpy
gnome84213953gnom_e
gramme114210333gramme
gramp106218323gramp_
grampa115010173grampa
gramps114114273gramps
grape84824663gr_ape
grime85021323grim_e
gripe84622963gr_ipe
grippe115310323grippe
grommet12268453grommet
groove10438873groove
groped107515053gro_ped
groper94517253gro_per
gropes95220403gro_pes
grosze16457733grosze
group85413923group_
grouped11419193grouped
grouper104210093grouper
groupie1045783groupie
groups94210513groups
grouse74315023grouse
grove95219333gro_ve
groyne1037213groyne
grume86218163grum_e
grump105115313grump_
grumped13337333grumped
grumps114510573grumps
grumpy14498153grumpy
guimpe1134723guimpe
home98042443_hom_e
homie104622523_homie
hope96639673_ho_pe
irone55126363iro_ne
krone94018733kro_ne
lope65941923_lo_pe
loupe75319513_loupe
mome85239353_mom_e
mope86838043_mo_pe
myope124010973myo_pe
nome66038423_nom_e
nope65934193_no_pe
oomph1236973_oomph
ope56845243__o_pe
oroide7311703oroide
pome85636693_pom_e
pomp106225463_pomp_
pomps115316193_pomps
pope85535613_po_pe
premie103617993premie
prime96525603prim_e
primp115615923primp_
primped14479153primped
primps124711823primps
probe94320813pro_be
prole74527793pro_le
prom87631693prom__
promine112819443promine
promise113415843promise
promo95619993prom_o
promoed12310083promoed
promos105116423promos
promote11313143promote
prompted1536903prompted
prompter1437983prompter
prompts1337473prompts
proms95426403prom_s
prone75332623pro_ne
prop85932813pro_p_
propel103714063pro_pel
proper104319953pro_per
propmen1338763propmen
propped113311953propped
props95726883pro_ps
prose75835123pro_se
prosper114012183prosper
prove104823193pro_ve
pyrope132810533pyro_pe
ramee74633853_ramee
ramie75027823_ramie
ramp85934003_ramp_
ramped114617903_ramped
ramps96224633_ramps
rape65041633_r_ape
rime65138883_rim_e
rimple103814583_rimple
ripe66038923_r_ipe
robe65335643_ro_be
roble75223023_roble
rode55844303_ro_de
roe36861073_ro__e
rogue66417533_rogue
role45851823_ro_le
rom59855633_rom__
roman75424823_roman
romeo73719703_romeo
rompers113412243_rompers
roms67038963_rom_s
roomie83013873roomie
roose56127093_roose
roped84630803_ro_ped
roper75431913_ro_per
ropes75940063_ro_pes
ropey106021873_ro_pey
ropy96323413_ro_py
roque144812133_roque
rose46148903_ro_se
rote46249023_ro_te
rotte54625933_rotte
roue45941743_ro_ue
rouge65423443_rouge
roup66627693_roup_
rouped95717353_rouped
roupet84218343_roupet
roups75118903_roups
roupy106112713_roupy
rouse56634703_rouse
route55132073_route
rove75136983_ro_ve
rump86729083_rump_
rumple103913013_rumple
rumps95922293_rumps
scope94821483sco_pe
shoppe133110313shoppe
slope75823563slo_pe
some66040383_som_e
stomp95616663stomp_
stomped124110533stomped
stomper114111223stomper
stomps105612833stomps
stope74727243sto_pe
stripe85822443str_ipe
strobe84513813stro_be
strode75215973stro_de
stroke105116173stro_ke
stroma84313073strom_a
stromal93010583stromal
strop77422243stro_p_
strophe1239133strophe
stropped1367333stropped
stropper1247753stropper
stroppy14205093stroppy
strops86220383stro_ps
strove95014793stro_ve
strumae9368093strumae
strumpet1256033strumpet
tame66343663t_am_e
tammie104212683tammie
tamp86133003t_amp_
tamped114317043t_amped
tamper104618513t_amper
tamps95524083t_amps
tape64538143t__ape
taupe7314163t_aupe
telome8311923telom_e
temp85323333t_emp_
temped113912893t_emped
tempeh13357463t_empeh
temper103914093t_emper
tempi94912203t_empi
temple102811333t_emple
tempo95214973t_empo
temps95417133t_emps
tempt95124843t_empt
theme105921733them_e
thole85620843tho_le
thorp104414263thorp_
thorpes125010353thorpes
thorps113610893thorps
those85218143tho_se
throe89321423thro__e
thrombi14134443thrombi
throne98517603thro_ne
throve128012393thro_ve
thump126211573thump_
thumped15387413thumped
thumper14356953thumper
thumps13449353thumps
thyme134612473thym_e
time66235013t_im_e
toe310166853t_o__e
togae67020113t_ogae
togue64816303t_ogue
toile54626493t_oile
toke86738493t_o_ke
tole46052903t_o_le
tom514358053t_om__
toman75724053t_oman
tomb89029653t_om_b
tombed113812133t_ombed
tombs97818733t_ombs
tomes76037383t_omes
tommed113310143t_ommed
tommy124712233t_ommy
toms68343493t_om_s
tone46953743t_o_ne
tonne54921433t_onne
toom66532933toom__
toonie63617993toonie
tootle62613813tootle
top510560683t_o_p_
toped85631313t_o_ped
topee76029953t_opee
toper75231023t_o_per
topes76941763t_o_pes
toph96326873t_o_ph
tophe106718973t_ophe
topi67830393t_o_pi
topo66932403t_o_po
topped114617723t_opped
topper103817603t_opper
topple104411323t_opple
tops66248123t_o_ps
toque145113093t_oque
tore47359323t_o_re
torose64317693torose
torque15237673torque
torse55833333t_orse
torte55431703t_orte
tote46643673t_o_te
toupee8316133t_oupee
touse55430673t_ouse
towie85821873t_owie
towrope1245583towro_pe
trace75829613tr_ace
trade65026043tr_ade
traipse935873traipse
tram67034553tram__
tramel84113713tramel
trammed123810713trammed
trammel11357663trammel
trampers123210373trampers
trampier12318233trampier
trampled13247903trampled
trampler12278003trampler
tramples122610203tramples
trams75327673tram_s
trance84718763trance
trap67532803tr_ap_
trapes85024463tr_apes
trapped124512213trapped
trapper113912793trapper
traps75727483tr_aps
trapt76433393tr_apt
trave85223033tr_ave
treble8311663treble
tree47745813tr__ee
tremble1138003tremble
tremor84210393tremor
triage72812893triage
tribe74420263tr_ibe
trice75127493tr_ice
tricep103911073tricep
triene64316383triene
trifle94012883trifle
trike95320163tr_ike
trim65329513trim__
trimer85717153trimer
trimly114410893trimly
trimmed12348933trimmed
trimmer113610833trimmer
trims75021473trim_s
trine54734603tr_ine
triode75311893triode
triose64715383triose
trip66830393tr_ip_
tripes85324873tr_ipes
triple84215923triple
tripped123911693tripped
tripper113711923tripper
trippet113714113trippet
trippy13457803trippy
trips74923363tr_ips
trisome9310223trisom_e
triste63818643triste
trite54730033tr_ite
triumph1453333triumph
triune64210183triune
troak95213573tro_ak
troaked12438253troaked
troaks104410593troaks
trocar848763trocar
trochee122613873trochee
troches123715343troches
trock114817603tro_ck
trocked144312243trocked
trocks123614633trocks
trod57627953tro__d
trodden934883trodden
troffer13125863troffer
trog57628213tro__g
trogon73611753trogon
trogs67022603tro_gs
troika1035493troika
trois57226093tro_is
troked114114583troked
trokes104019263trokes
troll54416533tro_ll
trolled84312263trolled
troller73913173troller
trolley10328753trolley
trolls64613943trolls
trolly94012353trolly
trombone1245353trombone
trommels12254333trommels
tromping13319593tromping
trona54118953tro_na
tronas63816893tronas
trones65629283trones
troopers10289423troopers
trooz145016153tro_oz
trophy1438283trophy
tropic103014193tropic
tropin83316753tropin
tropine93116653tropine
trot46351313tro__t
troth85622203tro_th
trothed114010973trothed
troths95414153troths
trots56629943tro_ts
trotted83711283trotted
trotter73312253trotter
trotyl9236673trotyl
trouble957703trouble
trough108512023trough
trounce936823trounce
troupers10359423troupers
trouser73812463trouser
trout57332573tro_ut
trouts66116623trouts
trouty95211793trouty
trover95014663trover
troves94719113troves
trow78031423tro__w
trowed104714653trowed
trowel94211463trowel
trows88826183tro_ws
trowth1277883trowth
troy77429683tro__y
troys86418613tro_ys
truce75118693tr_uce
trudge8318733trudge
true46725853tr__ue
truffe1276233truffe
trumpery1533613trumpery
trumpets12315573trumpets
tryma1037223trym_a
tryste9399583tryste
tump85927033t_ump_
tumped114216233t_umped
tumps95420793t_umps
type96223743t__ype
whomp155011323whomp_
whomped18345473whomped
whomps16457603whomps
wrote84717483wro_te

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127165177.14315779.9
3Display Results5175170.1563314.1
 (SQL Overall)1786915177.43924020.8
 
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.