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

127 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
poleaxe165630(None) 
poleax1547991poleax_
poleaxed1854821poleaxed
poleaxes1767271poleaxes
oleate6318882_oleate
paleae84820292palea_e
paleate94120002paleate
pileate93815922pileate
please84315732p_lease
bolete8519613bole_te
cleave114212513_cleave
colead94114643colea_d
coleader1139183coleader
coleads102911423coleads
collage102813763collage
collate92919683collate
deleave1147723deleave
folate93320393fol_ate
foliage1147533foliage
foliate10513533foliate
foveae1237563fovea_e
foveate1338363foveate
galeae74717453galea_e
galeate83916793galeate
lease55230263__lease
leave84723723__leave
maleate94117543maleate
mileage10299313mileage
olea46532723_olea__
oleates7417833_oleates
oleine6313793_oleine
palace104516923pal_ace
palate84226793pal_ate
palea75028663palea__
paleal84716673palea_l
paleface1545343paleface
palette93613983palette
palmate113215233palmate
palpate113213923palpate
peace95026083p__eace
peage84723573p__eage
pease75231113p__ease
pelage9515363pel_age
peltate92013773peltate
pickaxe2244623pickaxe
pilea75123953pilea__
pileated112711133pileated
pillage103412603pillage
pipeage1236203pipeage
place94824613p_l_ace
plage84520403p_l_age
plane74929143p_l_ane
plate74635113p_l_ate
plea66830603p_lea__
pleach134211243p_leach
plead85818463p_lea_d
pleaded113511263p_leaded
pleader103511753p_leader
pleads94613953p_leads
pleas75627033p_lea_s
pleased103712073p_leased
pleaser93912343p_leaser
pleases94515483p_leases
pleat74734473p_lea_t
pleated103816633p_leated
pleater93916333p_leater
pleats85218593p_leats
plebe95014873p_le_be
pledge10469493p_ledge
plex137321373p_le_x_
plexal1536843p_lexal
plexes155313543p_le_xes
polar75623453pol_a_r
polars84419353pol_ars
pole65951303pol___e
poleaxing1944873poleaxing
polecat11313143polecat
polecats1248833polecats
poled84934843pole__d
poleis86018353pole_is
polemic13311253polemic
polemize2148673polemize
polenta9310093polenta
poler74431793pole__r
polers84225643pole_rs
poles75351003pole__s
poleward1455943poleward
poleyn1157323pole_yn
poleyns1236113poleyns
police102918563pol_ice
polite83625073pol_ite
polka11310413polka__
polkaed1435323polkaed
polkas1239103polka_s
pollack1567333pollack
pollard103511143pollard
pollee83623273pol_lee
pollenate1157143pollenate
pollex153711163pollex_
pollute937383pollute
polyene1259363polyene
pomace123111913po_mace
pomade113611333po_made
portage103013643portage
postage103214853postage
potage92715903po_tage
potence11711363potence
pottage103310603pottage
prelate9519693prelate
prolate9419793prol_ate
protease10209893protease
pulsate9510233pulsate
release7312763release
roseate7613453roseate
sleave94714153_sleave
sleaze152611863_sleaze
solace83415823sol_ace
solate64526073sol_ate
solvate102710213solvate
spoliate1039243spoliate
tolane64316583tol_ane
tolerate8312323tolerate
tollage82610163tollage
toluate7159343toluate
voltage1136863voltage
volvate13317993volvate
zoeae144412483zo_ea_e

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.406440125.6
2DLD Change Limit1340271277.26618445.8
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.71823152.5
 
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.