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

167 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
peepul103578(None) 
peepuls1134921peepuls
peel65535612pee__l
peep85833692peep__
peeped113915392peeped
peeper103614802peeper
peeps95822362peep_s
ampul91110853_ampul
beep85931213beep__
beeped115313453beeped
beeper103714093beeper
beeps95320973beep_s
befoul1137253befoul
deep76031883deep__
deepen9339193deepen
deeper93613503deeper
deeply1257013deeply
deeps84921773deep_s
eel37946843_ee__l
expel1448233_expel
eyeful1235903eyeful
feel75233843fee__l
gleeful1144323gleeful
heedful1444313heedful
heel75034223hee__l
helpful1543963helpful
ireful948713ireful
jeep135624843jeep__
jeeped16469843jeeped
jeeps144715373jeep_s
keel85729473kee__l
keep106329823keep__
keeper123811923keeper
keeps116020283keep_s
keypal1534893keypal
needful1143863needful
neep65728313neep__
neeps75617883neep_s
pageful1346353pageful
palpal104112053palpal
palpus104210283palpus
panful1179743panful
papal95820673p_apal
pappus9408373pappus
papula103011113p_apula
papule102212133p_apule
peaceful1545463peaceful
peal68648103p_e_al
peanut8318183peanut
pearl75324463p_earl
pedal86022503p_edal
pee56066513pee___
peed76239183pee__d
peeing94618083peeing
peek106031433pee__k
peeked134314583peeked
peeks115021113pee_ks
peeled94119713peeled
peeler83517383peeler
peels75226423pee_ls
peen65938083pee__n
peened94318163peened
peens76428193pee_ns
peepers113713673peepers
peephole1545983peephole
peeping123615213peeping
peer66238353pee__r
peered93819493peered
peerie83617893peerie
peers75130273pee_rs
peery105719443pee_ry
pees65257373pee__s
peeve104915253pee_ve
peeved124112893peeved
peeves113814873peeves
peewee11311963peewee
peewit111110903peewit
pekepoo1543363pekepoo
penal75228373p_enal
pencel103812913pencel
pencil103712973pencil
penial84120893penial
pensil83013333pensil
pentyl1138813pentyl
penult8314653p_enult
people10310193people
pep76447083p_ep__
pepla9312863p_epla
peplum12156823peplum
peplus10138343peplus
pepo87622153p_ep_o
pepos96620083p_epos
pepped103113403pepped
pepper93512943pepper
peppily1335133peppily
peppy114310363p_eppy
peps85134513p_ep_s
perdu84216273perdu_
perdue93912633perdue
perdus93711273perdus
peril75425953p_eril
perp89029893perp__
perps95521483perp_s
petal76526893p_etal
petrel83111533petrel
petrol82714063petrol
peyotl1146233peyotl
phenol1149253phenol
phenyl1435323phenyl
picul95015363p_icul
pipal95118353p_ipal
pipeful1445643pipeful
plenum1039503plenum
plexal1536843plexal
plexus15377283plexus
potful1138083potful
prebuy1357423prebuy
precut102016533precut
prep86427673prep__
prepay13310313prepay
prepill1147583prepill
preppy1235523preppy
preps96220693prep_s
prepuce1337833prepuce
prepupa1064023prepupa
prepupal1164263prepupal
prequel1836343prequel
prevue1179163prevue
propel103714063propel
propyl13358183propyl
pseud867043pse_ud
pul56138063___pul
pulpal10408453pulpal
pupal97616873p_upal
pupil94712983p_upil
pupu87620713p_upu_
pupus94614043p_upus
reel45240533ree__l
reexpel1643183reexpel
repeal84718283repeal
repel74921403_repel
rueful948203rueful
seel45042983see__l
seep66540343seep__
seeped94317523seeped
seeps74828753seep_s
seepy104717973seep_y
sepal77723003_sepal
speedup1272983speedup
speel74420763spee__l
teel46335803tee__l
teenful1045563teenful
teepee8314363teepee
tepal76319583_tepal
useful947013useful
veep95325093veep__
veepee11311483veepee
veeps104715723veep_s
waeful1238123waeful
weel75834083wee__l
weep95131653weep__
weeper114313303weeper
weepie11258793weepie
weeps104120563weep_s
weepy134212593weep_y
weevil1295433weevil
woeful1236363woeful

Search took 7 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 Limit1127161675.66019914.5
3Display Results1671670.0463630.4
 (SQL Overall)1786911676.07929394.8
 
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.