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

151 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
repo6602754(None) 
pepo87622151pepo
redo56029361redo
rep55847801rep_
repos74725791repos
repot75132621repot
repp85418741repp
repro75315911repro
reps65937951reps
aero45435342aero
apo511142122_apo
arepa75615562arepa
capo85829212capo
cep75736332cep_
cepe84926652cepe
ceps86125952ceps
cero66329452cero
credo84815562credo
crepe95520722crepe
crepon1039932crepon
crept95125892crept
crepy124812702crepy
deco76125972deco
demo77427552demo
depot85727922depot
ego46726052_ego
epos66723732_epos
ergo56420152ergo
expo1349182expo
grego7310522grego
helo75332852helo
hep86644142hep_
hero74635782hero
hypo127516352hypo
keno87926432keno
kep96437202kep_
kepi105315632kepi
keps106027302keps
kept106232942kept
keto86223452keto
leno47331392leno
lept66440882lept
levo76820062levo
memo85924792memo
meno66031352meno
pep76447082pep_
pepos96620082pepos
peps85134512peps
peso66925822peso
preop94715872preop
prep86427672prep_
preps96220692preps
rap56261962rap_
rape65041632rape
raps66247732raps
rapt67245312rapt
rato45436972rato
re26153742re__
read55942532read
real45750292real
ream65841612ream
reap65934742reap
reaps75626192reaps
rear45644552rear
reb55844962re_b
rebop9313282rebop
rebs65733562rebs
rec55645462re_c
reck106130562reck
recon75624242recon
recs65734182recs
recto74520802recto
red46755802re_d
redd66323172redd
rede55037662rede
redon65424882redon
redos65126762redos
redox134714232redox
reds56042862reds
ree37974072re_e
reed55549622reed
reef74938212reef
reek85232522reek
reel45240532reel
rees45364192rees
ref66053292re_f
refs75732242refs
reft75141272reft
reg46146492re_g
regs55436572regs
rei35647252re_i
reif76937652reif
rein46040892rein
reis45343232reis
rely75428952rely
rem56150042re_m
rems66237722rems
rend56136572rend
rent46661242rent
repay104818452repay
repeg84015052repeg
repel74921402repel
repin75324702repin
replot83818592replot
replow114210342replow
reply104015852reply
repoll8410792repoll
report85326012report
repose84121412repose
repots85621002repots
repour8310992repour
repps95114342repps
repros84216002repros
res35565042re_s
resh76523452resh
resod64720052resod
resow88217242resow
respot83117632respot
rest46459842rest
ret35982832re_t
rete44944132rete
retro55020952retro
rets45352562rets
rev65336622re_v
revs75027052revs
rewon86920572rewon
rex105740992re_x
rho65924832r_ho
rip56851302rip_
ripe66038922ripe
rips66237432rips
rope65542912rope
ropy96323412ropy
roto45935052roto
sego56525182sego
sepoy10314302sepoy
sept65844362sept
tempo95214972tempo
tepa66021682tepa
tepoy10312162tepoy
topo66932402topo
typo95418122typo
upo58925862_upo
uredo65112992uredo
veto76622992veto
wept95635052wept
yep86638962yep_
yeps95924402yeps
zep147129142zep_
zeps156019342zeps
zero134822472zero

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.0762351197.4
2DLD Change Limit298721511.14326134.7
3Display Results1511510.0761986.8
 (SQL Overall)1786911511.295137985.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.