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

132 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
ripen7561926(None) 
ripe66038921ripe_
riped85226431riped
ripens85012171ripens
riper74328401riper
ripes75435771ripes
risen54621881risen
riven85121621riven
arisen65316792arisen
arpen74418042arpen
aspen75216092aspen
biped104718832biped
copen94826432copen
cripe95521142cripe_
cripes105120872cripes
crispen11348202crispen
dizen155214932dizen
driven105210142driven
gien56330022gi_en
gipon84212412gipon
given95915282given
gripe84622962gripe_
griped104114712griped
griper94114612griper
gripes94619872gripes
gripey124111202gripey
gripmen1235032gripmen
kippen14299012kippen
lien45339802li_en
liken911818842liken
limen75426032limen
linen55728722linen
lipe66839732lipe_
lipin75518892lipin
lippen103911402lippen
liven85021732liven
mien65028352mi_en
mispen10312172mispen
mizen164815272mizen
open66427002_open
pen56558842__pen
pigpen1136582pigpen
pipe86434432pipe_
piped105123162piped
piper96523192piper
pipes96030142pipes
pipet95533322pipet
ramen75625192ramen
rape65041632rape_
raped85334622raped
raper74932752raper
rapes75740722rapes
rappen103512712rappen
raven84723442raven
reopen8311572reopen
repeg84015052repeg
repel74921402repel
repent84728872repent
repin75324702repin
ribes75530172ribes
rice64942912rice_
riced85825542riced
ricer74726612ricer
rices75536152rices
richen113812512richen
ricin74620212ricin
ridden83511722ridden
ride55945122ride_
rident7520192rident
rider65231302rider
rides66140812rides
riel46432382ri_el
rife74632322rife_
rifer84721982rifer
rile45650532rile_
riled65833252riled
riles55343642riles
riley84420582riley
rime65138882rime_
rimed84826372rimed
rimer75429242rimer
rimes75634542rimes
rin36663182ri__n
rip56851302rip__
ripely112511152ripely
ripened1038202ripened
ripener937902ripener
ripest84317932ripest
ripieni944112ripieni
ripieno944132ripieno
riping93821612riping
ripped114419012ripped
ripper103518652ripper
rips66237432rip_s
rise45945232rise_
riser55431052riser
rises55244042rises
rite45849452rite_
rites54442552rites
rive75537722rive_
rived94825612rived
river85731692river
rives85336002rives
rivet85636362rivet
rope65542912rope_
roped84630802roped
roper75431912roper
ropes75940062ropes
ropey106021872ropey
rouen54920902rouen
roven85521972roven
rowen84921152rowen
rumen74419502rumen
rupee7321282rupee
sipe67341042sipe_
siped84927682siped
sipes76036952sipes
siren54525822siren
tripe75425382tripe_
tripes85324872tripes
unpen72913572unpen
vimen104114752vimen
viper105017302viper
vixen153010022vixen
widen94717972widen
wipe94830282wipe_
wiped114722082wiped
wiper105421292wiper
wipes104827082wipes
wizen175813862wizen
yipe96722172yipe_
yipes106017842yipes

Search took 4 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.346516448.0
2DLD Change Limit538001322.37322671.7
3Display Results1321320.0462869.6
 (SQL Overall)1786911322.76564626.0
 
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.