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 “pleas” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

227 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
pleas7562703(None) 
fleas86423661fleas
leas45954181_leas
peas65755061p_eas
plea66830601plea_
plead85818461plead
pleads94613951pleads
please84315731please
pleat74734471pleat
pleats85218591pleats
plebs95814581plebs
plews105415351plews
alas46358122al_as
albas75925392albas
alecs76620732alecs
alefs87319662alefs
ales47067102ale_s
alfas87219042alfas
algas65624932algas
alias55834602alias
almas76629772almas
apneas83211382apneas
areas55935772areas
bleak115915382bleak
bleaks125112432bleaks
blear75918682blear
blears85116452blears
bleat75737002bleat
bleats85518612bleats
blebs96416152blebs
bless75917812bless
blets75324942blets
clean75420412clean
cleans85817052cleans
clear76219052clear
clears84116562clears
cleat76335062cleat
cleats84919312cleats
clefs106616242clefs
clews105516332clews
flea75628492flea_
fleam106017282fleam
fleams115011942fleams
flees85828752flees
flews115316442flews
fleys117015602fleys
galeas74618512galeas
gleam86916732gleam
gleams94812252gleams
glean65818202glean
gleans75014742gleans
gleds75417892gleds
glees65027592glees
glens66519852glens
gleys96514852gleys
glias64618492glias
ideas65919012ideas
ilea45931462ilea_
ileac75814172ileac
ileal56118082ileal
ileus54616892ileus
keas86337092_keas
las37281472_l_as
lea37660182_lea_
lead56038852_lead
leads66028492_leads
leaf76441032_leaf
leafs85721182_leafs
leak86233712_leak
leaks95923912_leaks
leal46043272_leal
lean46345242_lean
leans55536252_leans
leap66032682_leap
leaps75522932_leaps
lear47045952_lear
lears55938732_lears
lease55230262_lease
leash85519212_leash
least56134882_least
lees45455882_lees
legs56133692_legs
leis45739602_leis
leks85427602_leks
lens46146492_lens
les35663072_le_s
less45635102_less
lets47147942_lets
leys76430182_leys
olea46532722olea_
oleos55419682oleos
oles46453472ole_s
ollas54218282ollas
pacas96029402pacas
paean77222722paean
paeans85118262paeans
palea75028662palea_
paleae84820292paleae
paleal84716672paleal
pales75753802pale_s
palets85122312palets
papas94927492papas
paras76143042paras
pas58775742p__as
pea56657242p_ea_
peag75431342p_eag
peags86122842p_eags
peak106535202p_eak
peaks114825622p_eaks
peal68648102p_eal
peals75235492p_eals
pean66147172p_ean
peans75437642p_eans
pear69745232p_ear
pears75138612p_ears
pease75231112p_ease
peat65967932p_eat
peats76140192p_eats
pecs84634102p_ecs
peds75835242p_eds
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peers75130272peers
pees65257372p_ees
pegs75531762p_egs
pehs95625762p_ehs
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
pens65649642p_ens
peps85134512p_eps
pes57259782p_e_s
pets66248332p_ets
pews95731532p_ews
pias66542552p_ias
picas94626522picas
piers75926332piers
pies66949602pie_s
pietas84516502pietas
pikas114218092pikas
pilea75123952pilea_
piles74742612pile_s
pileus84514942pileus
pimas94725102pimas
pinas75434452pinas
pitas77427672pitas
plan65833942pl_an
plans75731272plans
plash104616562pl_ash
plasm94114632pl_asm
plat66048872pl_at
plats75531372plats
play95928982pl_ay
playas114612282playas
plays106320772plays
plazas17409912plazas
pleach134211242pleach
pleased103712072pleased
pleaser93912342pleaser
pleases94515482pleases
pleb86123812ple_b
plebe95014872plebe
plebes104313622plebes
pled75231432ple_d
pleiad947832pleiad
pleiads1045222pleiads
plena75816392plena
pleon74216382pleon
pleons84213342pleons
pleuras937412pleuras
plew97222812ple_w
plex137321372ple_x
plexal1536832plexal
plexes155313532plexes
plexus15377282plexus
pliers84715152pliers
plies74526512plies
plods85719292plods
plops95920332plops
plots75025672plots
plows105419902plows
ploys105816592ploys
plugs85213492plugs
plums94619952plums
plus66324832pl_us
plyers114912982plyers
poems95715552poems
poets76024442poets
poleax1547992poleax
poleis86018352poleis
polers84225642polers
poles75351002pole_s
polkas1239102polkas
prees75937172prees
preps96220692preps
presa74319042presa
press75425952press
preys105717782preys
proas75028802proas
psoas75012982psoas
pujas145513322pujas
pulers83820282pulers
pules74538812pule_s
pumas95121562pumas
punas74826752punas
pupas95219282pupas
pyas96225702p_yas
pyes95528992pye_s
rheas84816952rheas
seas45755272_seas
sheas86331792sheas
sleds64418852sleds
slews86220352slews
teas45851492_teas
toeas55726422toeas
ulemas888962ulemas
ulnas55716532ulnas
ulvas84511502ulvas
upleap10106842upleap
upleaps1185232upleaps
ureas55826012ureas
uveas84912282uveas
yeas78638422_yeas
ylems1039262ylems
zoeas145815612zoeas

Search took 4 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 Filter178691538000.203880251.2
2DLD Change Limit538002273.18616886.4
3Display Results2272270.1261801.6
 (SQL Overall)1786912273.51550836.7
 
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.