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

421 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
pomaces13271212(None) 
pomace123111911pomace_
pomades123711731pomades
boraces113716852boraces
comakes154413642comakes
comates114123632comates
homages131011582homages
maces97139962__maces
paces96741112p__aces
palaces114216452palaces
peaces106324082p_eaces
places104323702p_laces
poaches144416942po_aches
polices113118052polices
pomaceous1544462pomaceous
pomade113611332pomade_
pomaded13377862pomaded
pomes94833932pom__es
pommies133712842pommies
ponces104720842po_nces
potages102416422potages
pounces114113892pounces
pumices1338272pumices
romances12310792romances
solaces93116132solaces
aces67645093___aces
almuces11316823almuces
amazes175613473_amazes
amices105018013_amices
anlaces92313733anlaces
apomicts1444193apomicts
apomixes1934853apomixes
bifaces1448063bifaces
bocces123912023bo_cces
bodices12710593bodices
bolases93315003bolases
bombes124916823bom_bes
bonacis11310323bonacis
borages103917163borages
boranes93720403boranes
borates94823013borates
boraxes163511633boraxes
bounces113813683bounces
braces108427773_braces
bromates12413133bromates
camases114216343camases
cimices13279803cimices
coaches144018693co_aches
coacts105314323co_acts
coaxes154715633co_axes
codices12512583codices
coerces11311943coerces
comade114415323comade_
comae97128423coma_e_
comake144413423comake_
comaker153410603comaker
comakers16339163comakers
comas95833003coma__s
comate104124843comate_
combes125321733com_bes
comes97246993com__es
comics124015563comic_s
commies133718443commies
compacts16368903compacts
compares143816433compares
comrades13149773comrades
comtes106222813com_tes
coracles121811163coracles
cowages13310933cowages
daces85030683__daces
damages11511273damages
defaces133213403defaces
dogfaces1554143dogfaces
dolmades1245463dolmades
domaines11611063domaines
domains10510873domains
domes85735563dom__es
domines102918973domines
donates83217223donates
dosages92310803dosages
dotages92311793dotages
effaces15277273effaces
enfaces122110913enfaces
enlaces92313393enlaces
faces106439433__faces
females12310663females
folates103218453folates
fomites123613203fomites
forages114217273forages
forces114422133fo_rces
formates132814293formates
fromages1437073fromages
glaces94218023_glaces
gouaches1436193gouaches
graces94523493_graces
grimaces1355383grimaces
hamates122917673hamates
hoaxes163611693ho_axes
hogmanes1446773hogmanes
homage121210603homage_
homaged1497413homaged
homager13107853homager
homagers1486823homagers
hombres14369873hombres
homes106938813hom__es
homies114524723hom_ies
homines123518633homines
humates122813193humates
hyraces1537913hyraces
images91411453_images
inlaces92512903inlaces
inmates92715763inmates
iodates8312893iodates
jounces16369853jounces
joyances2044413joyances
laces76141763__laces
loaches123613983lo_aches
loaves94813853lo_aves
locales93715093locales
locates93218813locates
lovages1138033lovages
mabes96331533__mabes
mace87345783__mace_
maced108528693__maced
macer912126943__macer
macers105321273__macers
maches134827233__maches
machs125722563__machs
macks135127603__macks
macles107023223__macles
macs86742503__mac_s
maes66948393__ma_es
mages85036023__mages
makes115336853__makes
males75049793__males
manes76648953__manes
mares76457633__mares
mates75251363__mates
maxes145629533__maxes
mazes165632173__mazes
menaces112715523menaces
momes95134473mom__es
mommies103912273mommies
momuses1159263momuses
monades103713823monades
morales93619403morales
nomads94711603noma_ds
nomarchs1543903nomarchs
nomas74726413noma__s
nombles113212343nombles
nomes74933123nom__es
nonages8313843nonages
nonces84418833no_nces
nopales93812523nopales
notates72817483notates
notices9312283notices
novices1238223novices
noyades1136563noyades
oases55330983_o_ases
oaves84925613_o_aves
ohmages13115093ohmages
ombres103911133_ombres
oomiacks1643533oomiacks
oomiacs1135683oomiac_s
opiates9312143opiates
oraches124216473_oraches
oracles93212423_oracles
orates64328613_orates
ounces83617773_ounces
pacas96029403p__acas
pace86345773p__ace_
paced106931683p__aced
pacer96131613p__acer
pacers105124543p__acers
pacey126720283p__acey
packs135528933p__acks
pacs85842183p__ac_s
pacts95125803p__acts
pages85235073p__ages
palace104516913palace_
palaced124110773palaced
palates93624933palates
pales75753803p__ales
panacea1137783panacea
panaceas1236763panaceas
panaches15310283panaches
panes76148693p__anes
papacies1439473papacies
parades104121463parades
pares77164483p__ares
pases75346503p__ases
patacas11311003patacas
pates76047893p__ates
pavanes123612653pavanes
paves104833923p__aves
paxes144928423p__axes
peace95026083p_eace_
peaced115818913p_eaced
peaches144120053p_eaches
peages94321843p_eages
peases85229473p_eases
pelages10714613pelages
penances12312443penances
penates93321593penates
peonages1138473peonages
pesades10310893pesades
phages125213513p_hages
phases114618403p_hases
phonates13410643phonates
phorates13413043phorates
phrases12711463phrases
pieces104217273p_ieces
pierces113411193pierces
pikakes1245823pikakes
pimas94725103pima__s
pimples133012423pimples
pinnaces12268863pinnaces
pipages1289423pipages
piracies12312643piracies
pirates93020323pirates
place94824613p_lace_
placed114318003p_laced
placer105117743p_lacer
placers114515263p_lacers
placet103923673p_lacet
placets113911223p_lacets
placks144414153p_lacks
plages94520153p_lages
plaices11411143plaices
planes85028083p_lanes
plates85432243p_lates
pleaches153210433pleaches
pleases94515483pleases
plumages1335653plumages
poaceous1267163po_aceous
poach124917863po_ac_h
poached154212403po_ached
poacher143912323po_acher
poachers152910763po_achers
poachy16388963po_achy
pocks135022963po__cks
podites103014733podites
poesies93217403poesies
pogies94123543po_gies
pointes93216753pointes
poises84226543po_ises
pokes116133013po__kes
pokies125921333po_kies
polars84419353pola_rs
poleaxes1767273poleaxes
poles75351003po__les
police102918563police_
policed123212233policed
policer113112683policer
policers12259993policers
policies122415663policies
polies84034583po_lies
pollacks1656373pollacks
pollees93215333pollees
pollices12410753pollices
pomander1347083pomander
pomanders1436223pomanders
pomatum1346393pomatum
pomatums1443793pomatums
pome85636693pom__e_
pomelos11218133pomelos
pomfret1446993pomfret
pomfrets1543033pomfrets
pommee122813283pom_mee
pommel12277453pom_mel
pommels13235783pommels
pommie123710503pommie_
pomos95321573pom__os
pompanos1445233pompanos
pompoms1535323pompoms
pompons1338543pompons
pompous1338053pompous
pomps115316193pom__ps
poms87037743pom___s
ponce95222513po_nce_
ponced114314813po_nced
pones74547043po__nes
pongees104212543pongees
ponies84833463po_nies
pontes83627853po_ntes
pooches143214163pooches
poodles103013513poodles
pooves113914713po_oves
popes95933813po__pes
poppies102816193poppies
popples103011873popples
popsies112816463popsies
populaces15195713populaces
porches143815673porches
pores75849033po__res
porgies103017003porgies
porkies133416493porkies
portages112613223portages
portances1349833portances
posadas1037193posadas
poses74642763po__ses
posies84431433po_sies
posoles9314883posoles
posses85128803po_sses
postages112815323postages
postfaces1656273postfaces
posties93128813posties
potables12179703potables
potage92715903potage_
potashes1337823potashes
potatoes1039943potatoes
potences12710693potences
potiches1539203potiches
potlaches16115263potlaches
potpies113116173potpies
potsies93019483potsies
pottages112910453pottages
potties93723543potties
pottles93816983pottles
pouches144116743pouches
pouffes15408123pouffes
pounce105214093pounce_
pounced123510623pounced
pouncer113511233pouncer
pouncers12349203pouncers
poxes145325723po__xes
pozoles1839063pozoles
prances113618773prances
prases84429023p_rases
prates84633163p_rates
praxes156215183p_raxes
preaches153214893preaches
preacts113211363preacts
prefaces15311063prefaces
prices104524543p_rices
primacies1548453primacies
primages13159273primages
primates121515933primates
princes113015143princes
probates12414263probates
produces1347903produces
profanes132311573profanes
promines123018803promines
promises122916763promises
promotes12314123promotes
pronates10418373pronates
propanes122415823propanes
prorates10418063prorates
protases102115033protases
ptomaines1345523ptomaines
ptomains1246053ptomains
puces94924633p__uces
pumas95121563puma__s
pumice1238223pumice_
pumiced1435173pumiced
pumicer1335063pumicer
pumicers1434353pumicers
pupates113311433pupates
races74943243__races
refaces123216743refaces
relaces93420883relaces
remakes134116173remakes
remates93827103remates
roaches123616213ro_aches
romaines10512513romaines
romajis1635903romajis
romance11311083romance_
romanced1337253romanced
romancer1247293romancer
romancers1345713romancers
romanos94311473romanos
romans84620243roma_ns
rosacea944713rosacea
rosaceas1043723rosaceas
rotates72819773rotates
rubaces1139303rubaces
smacks144112323_smacks
smazes174311663_smazes
soaves94218673so_aves
socages101012053socages
solace83415823solace_
solaced102911063solaced
solacer93011103solacer
solacers10268893solacers
solates73523853solates
somans84619303soma_ns
somas76030373soma__s
somites94219113somites
sonances10310263sonances
sources9312173sources
spaces104722633_spaces
stomachs1544953stomachs
stomates10313343stomates
sumachs14457353sumachs
sumacs105512103sumac_s
taces76237803__taces
tamales93216143tamales
tenaces92814513tenaces
thoraces13118933thoraces
tolanes74216303tolanes
tomans85419133toma_ns
tomatoes1038603tomatoes
tombacks18216453tombacks
tombacs13248433tombac_s
tomcats11127773tomcats
tomes76037383tom__es
tommies113812983tommies
topazes1857313topazes
towages1139233towages
traces85329933_traces
unlaces92513623unlaces
unmakes132810793unmakes
vivaces1536413vivaces
voces105918053vo__ces
voices114414013vo_ices
voyages1435703voyages
womaned1337213womaned
womans114613653woma_ns
zombies2037983zombies
zouaves1933893zouaves
zymases21938333zymases

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274217.00019146.7
3Display Results4214210.1562698.7
 (SQL Overall)1786914217.31224438.0
 
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.