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

130 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
repp8541874(None) 
reap65934741reap
rep55847801re_p
repo66027541repo
repps95114341repps
reps65937951reps
app76827602_app
arepa75615562arepa
beep85931212beep
cep75736332ce_p
cepe84926652cepe
ceps86125952ceps
creep95218102creep
crepe95520722crepe
crept95125892crept
crepy124812702crepy
deep76031882deep
heap96432892heap
help95328922help
hemp115725622hemp
hep86644142he_p
jeep135624842jeep
keep106329822keep
kelp105322802kelp
kemp126418762kemp
kep96437202ke_p
kepi105315632kepi
keps106027302keps
kept106232942kept
kreep114610412kreep
leap66032682leap
lept66440882lept
neap66927012neap
neep65728312neep
peep85833692peep
pep76447082pe_p
pepo87622152pepo
peppy114310362peppy
peps85134512peps
perp89029892perp
preop94715872preop
prep86427672pre_p
preppy1235522preppy
preps96220692preps
ramp85934002ramp
rap56261962r_ap
rape65041632rape
raps66247732raps
rapt67245312rapt
rasp66029162rasp
re26153742re__
read55942532read
real45750292real
ream65841612ream
reaps75626192reaps
rear45644552rear
reb55844962re_b
rebop9313282rebop
rebs65733562rebs
rec55645462re_c
recap95718022recap
reck106130562reck
recs65734182recs
red46755802re_d
redd66323172redd
rede55037672rede
redip87816962redip
redo56029362redo
reds56042862reds
ree37974072re_e
reed55549622reed
reef74938212reef
reek85232522reek
reel45240532reel
rees45364192rees
ref66053292re_f
refs75732242refs
reft75141272reft
reg46146492re_g
regs55436572regs
rei35647252re_i
reif76937652reif
rein46040892rein
reis45343232reis
rely75428952rely
rem56150042re_m
remap95418102remap
rems66237722rems
rend56136572rend
rent46661242rent
repay104818452repay
repeg84015052repeg
repel74921402repel
repin75324702repin
reply104015852reply
repos74725792repos
repot75132622repot
repped114616722repped
repro75315912repro
repump1235682repump
res35565042re_s
resh76523452resh
rest46459842rest
ret35982832re_t
rete44944132rete
rets45352562rets
rev65336622re_v
revs75027052revs
rex105740992re_x
rip56851302r_ip
ripe66038922ripe
rips66237432rips
romp85926572romp
rope65542912rope
ropy96323412ropy
roup66627692roup
rump86729082rump
seep66540342seep
sept65844362sept
temp85323332temp
tepa66021682tepa
typp115812782typp
veep95325092veep
weep95131652weep
wept95635052wept
yelp95621352yelp
yep86638962ye_p
yeps95924402yeps
zep147129142ze_p
zeps156019342zeps

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 Filter178691298720.280638182.1
2DLD Change Limit298721300.78338150.7
3Display Results1301300.0304333.3
 (SQL Overall)1786911301.093163486.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.