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

138 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
pleat7473447(None) 
bleat75737001bleat
cleat76335061cleat
peat65967931p_eat
plat66048871pl_at
plea66830601plea_
plead85818461plead
pleas75627031pleas
pleats85218591pleats
alert54740652alert
beat66168302_beat
blat66550952bl_at
bleak115915382bleak
blear75918682blear
bleats85518612bleats
blent76230952blent
blest76431722blest
blet66247672ble_t
bloat75229922bloat
cheat105732452cheat
clean75420412clean
clear76219052clear
cleats84919312cleats
cleft106222852cleft
clept95725772clept
eat36989052__eat
elect74327032elect
feat76458222_feat
flat77147822fl_at
flea75628492flea_
fleam106017282fleam
fleas86423662fleas
fleet85932332fleet
float85928572float
gleam86916732gleam
glean65818202glean
gleet65532342gleet
gloat65427682gloat
great66034242great
heat77061422_heat
ilea45931462ilea_
ileac75814172ileac
ileal56118082ileal
lat37593402_l_at
lea37660182_lea_
lead56038852_lead
leaf76441032_leaf
leak86233712_leak
leal46043272_leal
lean46345242_lean
leant56737782_leant
leap66032682_leap
leapt75027472_leapt
lear47045952_lear
leas45954182_leas
least56134882_least
leet45957902_leet
left76340482_left
lent46360532_lent
lept66440882_lept
lest46956322_lest
let36481472_le_t
meat66359602_meat
neat46356782_neat
olea46532722olea_
oleate6318882oleate
paean77222722paean
palea75028662palea_
paleae84820292paleae
paleal84716672paleal
paleate94120002paleate
palest83926222palest
palet74650802pale_t
pat58089462p__at
pea56657242p_ea_
peag75431342p_eag
peak106535202p_eak
peal68648102p_eal
pean66147172p_ean
pear69745232p_ear
peart76440752p_eart
peas65755062p_eas
peats76140192p_eats
peaty105725692p_eaty
pelt67651082p_elt
pent66559072p_ent
pert66759322p_ert
pest65555292p_est
pet56477302p_e_t
phat95837862p_hat
pieta75421752pieta
pilea75123952pilea_
pileate93815922pileate
plait75631572plait
plan65833942pl_an
plant75437112plant
plate74635112pl_ate
plats75531372pl_ats
platy105021662pl_aty
play95928982pl_ay
pleach134211242pleach
pleads94613952pleads
please84315732please
pleated103816632pleated
pleater93916332pleater
pleb86123812ple_b
plebe95014872plebe
plebs95814582plebs
pled75231432ple_d
pleiad947832pleiad
plena75816392plena
plenty11311412plenty
pleon74216382pleon
plew97222812ple_w
plews105415352plews
plex137321372ple_x
plexal1536842plexal
pliant83918822pliant
plot66141232pl_ot
poet65552902poe_t
poleax1547992poleax
polecat11313142polecat
prat65952042p_rat
preact103220392preact
prest75736352prest
seat47575562_seat
slat46959022sl_at
sleet55639132sleet
slept75728102slept
splat76129342spl_at
splent84720192splent
sweat85628402sweat
teat45963632_teat
treat56240352treat
upbeat10911512upbeat
upleap10106842upleap
upleapt11116862upleapt
wheat114924572wheat

Search took 2 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.326548131.9
2DLD Change Limit538001381.59333772.8
3Display Results1381380.0463000.0
 (SQL Overall)1786911381.96590936.9
 
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.