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

103 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
polecat1131314(None) 
polecats1248831polecats
pleat74734472p_le_at
poleax1547992pole_ax
polenta9310092polenta
polycot14510122polycot
applecart1553603applecart
bleat75737003_ble_at
bobcat12411253bo_bcat
cleat76335063_cle_at
colead94114643cole_ad
collect113314593collec_t
colocate12313443colocate
copycat1647593copycat
cosecant12410683cosecant
dovecot1356733dovecot
elect74327033_elec_t
forecast1349763forecast
hellcat12410173hellcat
molest85022743mole_st
ocicat101412813_ocicat
olea46532723_ole_a_
oleate6318883_ole_ate
palea75028663pale_a_
paleae84820293pale_ae
paleal84716673pale_al
paleate94120003pale_ate
palest83926223pale_st
palet74650803pale__t
paletot9413713paletot
peat65967933p__e_at
pecan91919033p__ecan
pelican1139433pelican
pilea75123953pile_a_
pileate93815923pile_ate
piolet83225643piole__t
placate11312433p_lacate
placet103923673p_lacet
plat66048873p_l__at
plea66830603p_le_a_
pleach134211243p_leach
plead85818463p_le_ad
pleas75627033p_le_as
pleats85218593p_le_ats
pleiad947833p_leiad
plena75816393p_lena_
plexal1536843p_lexal
plica9613373p_lica_
plicae10410953p_licae
plical10411683p_lical
plicate11314513p_licate
podesta1036763podesta
poet65552903po_e__t
polar75623453pol__ar
pole65951303pole___
poleaxe1656303poleaxe
poled84934843pole__d
poleis86018353pole_is
polemic13311253polemic
polemical1547343polemical
polemist12412363polemist
polentas1038753polentas
poler74431793pole__r
polers84225643pole_rs
poles75351003pole__s
polestar1047113polestar
poleward1455943poleward
poleyn1157323pole_yn
poleyns1236113poleyns
police102918563polic_e
policed123212233policed
policer113112683policer
polices113118053polices
policy133211513polic_y
polka11310413pol_ka_
polkas1239103pol_kas
pollack1567333pollack
pollenate1157143pollenate
pollical1247953pollical
pollist9816603pollist
poloist91016323poloist
polycots1547763polycots
polymath1875963polymath
ponent82821593pone_nt
porrect1159743porrec_t
potent84223353pote_nt
preact103220393p_react
precast11314853p_recast
precut102016533p_recut
prelect111013833prelec_t
project1838453projec_t
prosect11313393prosec_t
protect11313633protec_t
select82621173selec_t
solecist10910783solecist
soleret7321233soleret
solicit9315743solicit
telecast1048303telecast
toecap1037323to_ecap
tolerant8411463tolerant
tolerate8312323tolerate
tomcat101013453to_mcat
wildcat1346293wildcat

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.410435831.7
2DLD Change Limit1340271037.42018062.9
3Display Results1031030.0303433.3
 (SQL Overall)1786911037.86022734.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.