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

143 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
poleaxes176727(None) 
poleaxe1656301poleaxe_
poleaxed1854811poleaxed
oleates7417832_oleates
pleases94515482p_leases
plexes155313532p_le_xes
poleax1547992poleax__
bolases93315003bol_ases
boletes9316063bole_tes
bollixes1747203bollixes
bolloxes1736833bolloxes
boraxes163511633bo_raxes
boreases10310253boreases
cleaves124111623_cleaves
coaxes154715633co__axes
coleader1139173coleader
coleaders1237803coleaders
coleads102911423colea_ds
coleuses1039713coleuses
collages113514233collages
collates103019133collates
culexes1636993cule_xes
deleaves1248063deleaves
dolmades1245463dolmades
flaxes165015353_fl_axes
flexes164512953_fle_xes
folates103218453fol_ates
foliages1247623foliages
foliates11412753foliates
galaxes1538873gal_axes
hoaxes163611693ho__axes
ilexes134510253_ile_xes
laxes125430093__l_axes
leases65428113__leases
leaves94222383__leaves
lexes127225263__le_xes
maleates103316343maleates
mileages11249693mileages
nontaxes1537853nontaxes
oleate6318883_oleate_
oleines7313393_oleines
palaces114216453pal_aces
palates93624933pal_ates
paleae84820293palea_e_
paleate94120003paleate_
palefaces1645303palefaces
palettes103112833palettes
palpates122613063palpates
paxes144928423p___axes
paxwaxes1942053paxwaxes
peaces106324083p__eaces
peages94321843p__eages
peases85229473p__eases
pelages10714613pel_ages
phloxes1935513phl_oxes
pickaxes2344913pickaxes
pileate93815923pileate_
pileated112711133pileated
pillages113012603pillages
pipeages1336423pipeages
places104323703p_l_aces
plages94520153p_l_ages
planes85028083p_l_anes
plates85432243p_l_ates
pleaches153210433p_leaches
pleaded113511263p_leaded
pleader103511753p_leader
pleaders113210183p_leaders
pleads94613953p_lea_ds
pleas75627033p_lea__s
please84315733p_lease_
pleased103712073p_leased
pleaser93912343p_leaser
pleasers104010293p_leasers
pleated103816633p_leated
pleater93916333p_leater
pleaters103613783p_leaters
pleats85218593p_lea_ts
plebes104313623p_le_bes
pledges113811563p_ledges
pleiades1145753p_leiades
plexus15377283p_le_xus
poesies93217403po_esies
polars84419353pol_a_rs
poleaxing1944873poleaxing
polecats1248833polecats
poleis86018353pole__is
poleless1089873poleless
polemics1448183polemics
polemizes2248143polemizes
polentas1038743polentas
polers84225643pole__rs
poles75351003pol___es
poleyns1236113pole_yns
polices113118053pol_ices
policies122415663policies
polies84034583pol__ies
polishes13711783polishes
polities102722343polities
polkaed1435323polka_ed
polkas1239103polka__s
pollacks1656373pollacks
pollards11299523pollards
pollees93215333pol_lees
pollenates1246743pollenates
pollices12410753pollices
pollutes1037613pollutes
polyenes13510063polyenes
pomaces132712123po_maces
pomades123711733po_mades
poperies12316793poperies
portages112613223portages
postages112815323postages
potages102416423po_tages
potences12710693potences
pottages112910453pottages
poxes145325723po___xes
praxes156215183p__raxes
prelates10418563prelates
prexes154915943p_re_xes
prolepses13126193prolepses
proteases112110823proteases
pulsates1048813pulsates
pyrexes19305833pyre_xes
relaxes143215323rel_axes
releases8313343releases
silexes1438653sile_xes
sleaves103813203_sleaves
sleazes162810333_sleazes
solaces93116133sol_aces
solates73523853sol_ates
soleuses838073soleuses
solvates11249673solvates
spoliates1138543spoliates
telefaxes1943813telefaxes
telexes1438343tele_xes
tolanes74216303tol_anes
tolerates9312113tolerates
tollages92410193tollages
toluates8138893toluates
voleries11313233voleries
voltages1237253voltages
volvoxes2142243volvoxes

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 Limit1461621437.09320606.5
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.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.