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

148 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
repos7472579(None) 
epos66723731_epos
pepos96620081pepos
redos65126761redos
repo66027541repo_
repose84121411repose
repot75132621repot
repots85621001repots
repps95114341repps
repros84216001repros
reps65937951rep_s
apos65433822_apos
arepas85515702arepas
capos94826072capos
cepes94424462cepes
ceps86125952cep_s
ceros74726072ceros
credos94612842credos
crepes105419342crepes
crepon1039932crepon
crepons1139312crepons
decos85522122decos
demos86022992demos
depose94215762depose
depot85727922depot
depots94716342depots
egos55821652_egos
eros45238452_eros
expos1449202expos
gregos847532gregos
helos84928062helos
heros84930862heros
hypos1312014742hypos
kenos95220622kenos
kepis115313362kepis
keps106027302kep_s
lenos56024862lenos
memos95719112memos
peplos101211542peplos
pepo87622152pepo_
peps85134512pep_s
pesos77221622pesos
preops104911932preops
preps96220692prep_s
rapes75740722rapes
raps66247732rap_s
ratos55528762ratos
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
rebop9313282rebop
rebops10311422rebops
rebs65733562re_bs
rebus75721112rebus
recks115625132recks
recon75624242recon
recons84922992recons
recs65734182re_cs
rectos85718782rectos
redds74617832redds
redes65139122redes
redo56029362redo_
redoes74623752redoes
redon65424882redon
redons75222182redons
redox134714232redox
reds56042862re_ds
reeds65430902reeds
reefs85121662reefs
reeks94124032reeks
reels55333262reels
rees45364192re_es
refs75732242re_fs
reges65628782reges
regs55436572re_gs
reifs84819092reifs
reins56234562reins
reis45343232re_is
rems66237722re_ms
rends65129952rends
rents55935182rents
rep55847802rep__
repass84114702repass
repast83520632repast
repay104818452repay
repays113813972repays
repeg84015052repeg
repegs93311942repegs
repel74921402repel
repels84318762repels
repin75324702repin
repins84924312repins
replot83818592replot
replots93412632replots
replow114210342replow
replows12329702replows
reply104015852reply
repoll8410792repoll
repolls939052repolls
report85326012report
reports94916212reports
reposal939112reposal
reposed103616272reposed
reposer93715332reposer
reposes94021262reposes
reposit9315862reposit
repour8310992repour
repours9310222repours
repp85418742rep_p
repro75315912repro
rerose63320842rerose
res35565042re__s
resod64720052resod
resods74116302resods
resow88217242resow
resows93915352resows
respot83117632respot
respots92912762respots
rests54935872rests
retros63820192retros
rets45352562re_ts
revs75027052re_vs
rewon86920572rewon
rexes124526952rexes
rhos76319062r_hos
ripes75435772ripes
ripost83615002ripost
rips66237432rip_s
ropes75940062ropes
rotos56027882rotos
segos64919482segos
sepoy10314302sepoy
sepoys1138472sepoys
septs75420602septs
telos55424522telos
tempos103812292tempos
tepas76521682tepas
tepoy10312162tepoy
tepoys1137542tepoys
topos75726392topos
tripos84014922tripos
typos106015812typos
uredos73910622uredos
yeps95924402yep_s
zeps156019342zep_s
zeros144918102zeros

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.0931921408.6
2DLD Change Limit538001481.43637465.2
3Display Results1481480.0463217.4
 (SQL Overall)1786911481.575113454.6
 
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.