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

392 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
rimes7563454(None) 
crimes105521581crimes
dimes85833041dimes
grimes94619031grimes
limes75636501limes
mimes95732021mimes
primes104225261primes
ribes75530171ribes
rices75536151rices
rides66140811rides
riles55343641riles
rime65138881rime_
rimed84826371rimed
rimer75429241rimer
rimers84522551rimers
rims65936301rim_s
ripes75435771ripes
rises55244041rises
rites54442551rites
rives85336001rives
times75630821times
acmes96020652acmes
aides65336602aides
aimed85626052aimed
aimer75926822aimer
aimers84621912aimers
aims67738182aim_s
almes75126542almes
amies76837692amies
animes84719592animes
arames84622572arames
arises65233802arises
armies85123692armies
berimes115216642berimes
bices95029962bices
bides85536772bides
bikes117529472bikes
biles75542142biles
bimas95521742bimas
bines76946792bines
biomes103815252biomes
bises75435622bises
bites75641172bites
bizes165923662bizes
bribes105918532bribes
brides94423512brides
bries74942152bri_es
brims94721622brim_s
brines85028852brines
brises84927612brises
bromes104719762bromes
brumes106417072brumes
cames97047312cames
chimes134922572chimes
cimex16119132cimex
cines75239682cines
cires74932912cires
cites74435582cites
climes104720002climes
comes97246992comes
cremes104517992cremes
cries75438402cri_es
crime94822692crime_
crimps124613452crimps
cripes105120872cripes
crises84529432crises
cymes1210118922cymes
dames85435852dames
demes86032692demes
dices86434242dices
dies55653522di_es
dikes105831332dikes
dime76237642dime_
dimer85625602dimer
dimers94321092dimers
dims75435022dim_s
dines66449152dines
dismes95617672dismes
dites66339152dites
dives95832402dives
domes85735562domes
dries64733672dri_es
drives105117112drives
emes65434662_emes
fames105735922fames
femes105626222femes
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
frames115119862frames
fries85535602fri_es
friges104116482friges
frises94124272frises
frites94922482frites
frizes184015462frizes
fumes105224702fumes
games86238552games
gibes84422522gibes
gies55641422gi_es
gimel8313352gimel
gimels938892gimels
gimmes113010902gimmes
gimps105915202gimps
gites65630182gites
gives95324872gives
glimes94717522glimes
grides84422362grides
grime85021322grime_
grimed104714092grimed
gripes94619872gripes
grumes94415552grumes
hames106138702hames
hemes105031082hemes
hides95129422hides
hies74842832hi_es
hikes125426982hikes
hims95230972him_s
hires86134342hires
hives116925512hives
homes106938812homes
ices66129642_ices
ides57734232_ides
imps86221122_imps
ires45639282_ires
irides74519122irides
irises64221172irises
jibes145520322jibes
jives154820812jives
kames115024692kames
kibes115521112kibes
kikes85122552kikes
kines95039132kines
kites95432542kites
krises105016082krises
lames75445542lames
lies46454192li_es
likes96231902likes
limas75627632limas
limbs96118942limbs
lime66244932lime_
limed85426802limed
limen75426032limen
limens84618032limens
limey104721042limey
limeys11429272limeys
limns75718392limns
limos75320812limos
limps95522672limps
lines57054572lines
lives86133192lives
memes94927702memes
mikes115129892mikes
miles74645072miles
mime85736402mime_
mimed105622732mimed
mimeo96018682mimeo
mimeos104511542mimeos
mimer94825762mimer
mimers105520182mimers
mines75651952mines
mires75640882mires
mises74740562mises
mites75141802mites
mixes147224402mixes
momes95134472momes
names74833362names
nides65229132nides
nims66226882nim_s
nines55937342nines
nites55736342nites
nixes124519622nixes
nomes74933122nomes
oximes15107422oximes
pies66949602pi_es
pikes115031032pikes
piles74742612piles
pimas94725102pimas
pimps114616982pimps
pines76048862pines
pipes96030142pipes
pixes144323172pixes
pomes94833932pomes
prices104524542prices
prides94324182prides
pries74339532pri_es
primas104418102primas
prime96525602prime_
primed115118912primed
primer105118682primer
primers114215672primers
primos104514422primos
primps124711822primps
prims95425932prim_s
primus103712172primus
prises84133172prises
prizes173819812prizes
races74943242races
rages64539442rages
raises64826542raises
rajes125022782rajes
rakes94440352rakes
rales54947492rales
ramee74633852ramee
ramees84620892ramees
ramen75625192ramen
ramet75743142ramet
ramets83517392ramets
ramies84630462ramies
ramps96224632ramps
rams65950772ram_s
ramus76418282ramus
rapes75740722rapes
rares55247442rares
rases55447212rases
rates55352012rates
raves85441972raves
raxes124729392raxes
razes145032702razes
redes65139122redes
rees45364192r_ees
reges65628782reges
regimes104514742regimes
reives95723042reives
remet74843722remet
remex146315792remex
rems66237722rem_s
res35565042r__es
retimes95020172retimes
rexes124526952rexes
rhemes115913182rhemes
rhymes14419822rhymes
rials55026672rials
rias45540592ri_as
ribs65833022ri_bs
rice64942912rice_
riced85825542riced
ricer74726612ricer
ricers84120992ricers
riches115022082riches
ricks115126132ricks
ride55945122ride_
rider65231302rider
riders74123902riders
ridges85817002ridges
rids56539542ri_ds
riel46432382ri_el
riels55121332riels
rife74632322rife_
rifer84721982rifer
rifest93114582rifest
riffs115114612riffs
rifles94217702rifles
rifs74929002ri_fs
rifts85718642rifts
rigs55137592ri_gs
rile45650532rile_
riled65833252riled
riley84420582riley
rilles64725502rilles
rills55032712rills
rim56052272rim__
rimier83916272rimier
rimiest93215852rimiest
rimless9369362rimless
rimmed114812302rimmed
rimmer103516032rimmer
rimmers113812882rimmers
rimose8310592rimose
rimous8311912rimous
rimples113114222rimples
rimy96621282rim_y
rinds64826142rinds
rings65029172rings
rinks94827102rinks
rins46153192ri_ns
rinse54820972rinse
rinses64720382rinses
riots54922012riots
ripe66038922ripe_
riped85226432riped
ripen75619262ripen
ripens85012172ripens
riper74328402riper
ripest84317932ripest
rips66237432ri_ps
rise45945232rise_
risen54621882risen
riser55431052riser
risers64624782risers
risks94917062risks
risus54216392risus
rite45849452rite_
ritzes154812942ritzes
rive75537722rive_
rived94825612rived
riven85121622riven
river85731692river
rivers94626542rivers
rivet85636362rivet
rivets94417112rivets
robes75133302robes
rodes614039082rodes
roes45954132r_oes
roles56747982roles
romeo73719702romeo
romeos84013172romeos
romps94617542romps
roms67038962rom_s
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
rubes74928412rubes
rues46044482r_ues
rules55234252rules
rumen74419502rumen
rumens83611812rumens
rumps95922292rumps
rums64833472rum_s
runes55530222runes
ruses56136582ruses
ryes75529352r_yes
rykes125513032rykes
semes75731582semes
sices75637272sices
sides65838362sides
sikes96236082sikes
simas75727552simas
simps94719762simps
sims65737172sim_s
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
slimes84722042slimes
stimes85920572stimes
tames75242012tames
tides64830152tides
ties45248312ti_es
tikes95628902tikes
tiles55542102tiles
time66235012time_
timed85223612timed
timer75626042timer
timers84420992timers
tines54848422tines
tires55437492tires
tomes76037382tomes
tribes85119022tribes
trices84826332trices
tries55742812tri_es
trikes105419492trikes
trimer85717152trimer
trimers94615142trimers
trims75021472trim_s
trines64132562trines
tripes85324872tripes
urines64724122urines
vibes104719952vibes
vices105725532vices
vies75238622vi_es
vimen104114752vimen
vims95423312vim_s
vines85137642vines
vires84529682vires
vises84427772vises
wames106432802wames
wides94832822wides
wifes114522562wifes
wiles85437872wiles
wimps125213802wimps
wines85546862wines
wipes104827082wipes
wires86034912wires
wises85633192wises
wites85536962wites
wives115328922wives
wizes174723342wizes
wries85827742wri_es
writes94420332writes
yikes125117752yikes
yipes106017842yipes
zines145232652zines
zymes1924712942zymes

Search took 3 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.0961861364.6
2DLD Change Limit538003921.79629955.5
3Display Results3923920.1103563.6
 (SQL Overall)1786913922.00289256.2
 
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.