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

172 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
plexor153525(None) 
flexor1634501flexor
plexors1645421plexors
flexors1734772flexors
pledgor11334992pledgor
pleon74216382ple_on
plessor9317692plessor
plex137321372plex__
plexal1536842plexal
plexes155313542plexes
plexus15377282plexus
pretor8315752pretor
alegar739283alegar
alexia132910463alexia
alexin132311483alexin
algor6513053al_gor
alienor7116303alienor
bevor101510813_bevor
blear75918683ble_ar
clamor1049453clamor
claxon1536583claxon
clear76219053cle_ar
clever114611533clever
decor84717573_decor
diplexer1844213diplexer
duplexer1842903duplexer
elector93313253elector
elevon977953elevon
elixir1333703elixir
exon117116803__exon
fetor81214533_fetor
flavor1236663flavor
fleer86020773fle_er
flex146123473flex__
flexed17419093flexed
flexes164512953flexes
flexion1735073flexion
flexure1743413flexure
floor84215233fl_oor
fluor84512773fl_uor
foetor939563foetor
glamor958183glamor
hexer155116683_hexer
ilex115822033ilex__
ilexes134510253ilexes
klaxon1733853klaxon
labor75117313_labor
laxer125420333_laxer
lear47045953_le_ar
lector83514983_lector
leer46239353_le_er
leger65721513_leger
lehr75514943_le_hr
lemon75618183_lemon
lemur739773_lemur
leno47331393_leno_
lenos56024863_lenos
leper74820743_leper
lessor64010603_lessor
lever85125163_lever
levo76820063_levo_
lex107943823_lex__
lexes127225263_lexes
lexis125916033_lexis
oleo46630483ole_o_
oleos55419683ole_os
paeon74819493pae_on
paler75436933pale__r
paletot9413713paletot
pallor8313673pallor
parlor8312673parlor
pastor84817483pastor
pavior1138533pavior
pawnor11357243pawnor
payor105413843p_ayor
pear69745233p_e_ar
pedro8313153p_edro
peeler83517383peeler
peeper103614803peeper
peer66238353p_e_er
pekoe114612363p_ekoe
pelon74423213p_elon
pelter83321623pelter
peon65635243p_e_on
pepo87622153p_epo_
pepos96620083p_epos
per56353093p_e__r
peso66925823p_eso_
pesos77221623p_esos
peter74427593p_eter
phenol1149253phenol
phenom1339473phenom
piecer105213083piecer
piefort1249533piefort
pier66035293pie__r
pilewort1389133pilewort
placer105117743placer
planar84212713planar
planer84122653planer
plater84427693plater
player115215213player
plea66830603ple__a
pleach134211243pleach
plead85818463ple_ad
pleader103511753pleader
pleads94613953pleads
pleas75627033ple_as
please84315733please
pleaser93912343pleaser
pleat74734473ple_at
pleater93916333pleater
pleats85218593pleats
pleb86123813ple__b
plebe95014873ple_be
plebes104313623plebes
plebs95814583ple_bs
plectra1145783plectra
pled75231433ple__d
pledge10469493pledge
pledgeor12303463pledgeor
pledger11359173pledger
pledgors12325263pledgors
pleiad947833pleiad
plena75816393ple_na
plenary1237543plenary
plench134010813plench
plenty11311413plenty
plenum1039503plenum
pleons84213343pleons
pleopod1244823pleopod
plessors10278253plessors
plethora1344823plethora
pleura837533pleura
pleuron976343pleuron
plew97222813ple__w
plews105415353ple_ws
plexiform2342313plexiform
plier75221283pl_ier
plod76723273pl__od
plop86625743pl__op
plot66141233pl__ot
plover115312613plover
plow95923233pl__ow
plower114315063plower
ploy96123603pl__oy
pluton838853pluton
plyer106214333pl_yer
poler74431793pole__r
poor65630223p__oor
praetor938973praetor
prefer113813203prefer
preform1439613preform
preop94715873pre_op
presort95219543presort
pressor93512883pressor
pretors9316813pretors
prewar114712583prewar
prework164210913prework
preworn124711223preworn
prex135722973prex__
prexes154915953prexes
prexy174611583prex_y
preyer114413733preyer
prior74316173p_rior
puler74826623pule__r
rhetor938063rhetor
senor53822803_senor
splendor1143753splendor
tenor53620253_tenor
tremor84210403tremor
vexer155513523_vexer
weldor10317653weldor

Search took 6 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.373479064.3
2DLD Change Limit1127161724.70623951.6
3Display Results1721720.0434000.0
 (SQL Overall)1786911725.12234887.0
 
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.