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

346 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
ribes7553017(None) 
bribes105918531bribes
gibes84422521gibes
jibes145520321jibes
kibes115521121kibes
ribs65833031rib_s
rices75536151rices
rides66140821rides
riles55343641riles
rimes75634541rimes
ripes75435771ripes
rises55244041rises
rites54442551rites
rives85336001rives
robes75133301robes
rubes74928411rubes
tribes85119021tribes
vibes104719951vibes
abbes96723522abbes
aides65336612aides
arises65233802arises
babes95834112babes
bes56557432__bes
bibbs84911582bibbs
bibles104617642bibles
bibs84831002bib_s
bices95029962bices
bides85536782bides
bikes117529472bikes
biles75542142biles
bines76946792bines
bises75435622bises
bites75641172bites
bizes165923662bizes
bribe94820782bribe_
bribed115312842bribed
bribee104316362bribee
bribees11409282bribees
briber104714052briber
bribers114111502bribers
brides94423512brides
bries74942152bri_es
brines85028852brines
brises84927612brises
caribes113715642caribes
cines75239682cines
cires74932912cires
cites74435592cites
cribs94516752crib_s
cries75438402cri_es
crimes105521582crimes
cripes105120872cripes
crises84529432crises
cubes95028162cubes
dibs76233692dib_s
dices86434242dices
dies55653532di_es
dikes105831332dikes
dimes85833042dimes
dines66449152dines
dites66339152dites
dives95832402dives
dribs85115062drib_s
dries64733672dri_es
drives105117112drives
fiber104921132fiber
fibers114717522fibers
fibres114312122fibres
fibs96329512fib_s
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fires85740752fires
fives116027362fives
fixes154723592fixes
fries85535602fri_es
friges104116482friges
frises94124272frises
frites94922482frites
frizes184015462frizes
gibe75927792gibe_
gibed96215962gibed
giber85417702giber
gibers95114662gibers
gibs75529282gib_s
gies55641432gi_es
gites65630182gites
gives95324872gives
grebes93813612grebes
grides84422362grides
grimes94619032grimes
gripes94619872gripes
gybes115012722gybes
hebes105521672hebes
hides95129432hides
hies74842842hi_es
hikes125426982hikes
hires86134342hires
hives116925512hives
ibex133813482_ibex
ibis66519582_ibis
ices66129642_ices
ides57734242_ides
ires45639282_ires
irides74519122irides
irises64221172irises
jibbs16609742jibbs
jibe136323402jibe_
jibed155114162jibed
jiber145115702jiber
jibers155912882jibers
jibs136724092jib_s
jives154820812jives
jubes145420742jubes
kibbes143811192kibbes
kibe106523462kibe_
kibei114311542kibei
kibeis12469802kibeis
kikes85122562kikes
kines95039142kines
kites95432552kites
krises105016082krises
libel74116102libel
libels85112692libels
liber74723622liber
libers84721442libers
libs66732772lib_s
lies46454202li_es
likes96231902likes
limes75636502limes
lines57054572lines
lives86133192lives
lobes75331002lobes
lubes74727992lubes
mabes96331532mabes
mibs85330492mib_s
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mires75640882mires
mises74740562mises
mites75141802mites
mixes147224402mixes
nabes75427092nabes
nibs65028322nib_s
nides65229142nides
nines55937342nines
nites55736342nites
nixes124519622nixes
obes66036832_obes
oribis838832oribis
pies66949612pi_es
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pixes144323172pixes
prices104524542prices
prides94324182prides
pries74339532pri_es
primes104225262primes
prises84133172prises
prizes173819812prizes
probes104119452probes
pubes94423402pubes
rabies85226022rabies
races74943242races
rages64539442rages
raises64826542raises
rajes125022782rajes
rakes94440352rakes
rales54947492rales
rapes75740722rapes
rares55247442rares
rases55447212rases
rates55352012rates
raves85441972raves
raxes124729392raxes
razes145032702razes
rebbes10313532rebbes
rebec94416542rebec
rebecs103913672rebecs
rebel73421292rebel
rebels84518132rebels
rebs65733562reb_s
rebus75721112rebus
redes65139132redes
rees45364192r_ees
reges65628792reges
reives95723042reives
res35565042r__es
rexes124526952rexes
rials55026672rials
rias45540602ri_as
rib56848042rib__
ribbed114014372ribbed
ribber103515492ribber
ribbers113913182ribbers
ribby12419682ribby
ribier84414232ribier
ribiers9319752ribiers
ribless93410342ribless
riblet84222442riblet
riblets93412552riblets
ribose839892ribose
riboses9310442riboses
rice64942922rice_
riced85825542riced
ricer74726612ricer
ricers84120992ricers
riches115022082riches
ricks115126132ricks
ride55945142ride_
rider65231312rider
riders74123902riders
ridges85817012ridges
rids56539562ri_ds
riel46432392ri_el
riels55121332riels
rife74632332rife_
rifer84721982rifer
rifest93114582rifest
riffs115114612riffs
rifles94217712rifles
rifs74929012ri_fs
rifts85718642rifts
rigs55137602ri_gs
rile45650542rile_
riled65833252riled
riley84420582riley
rilles64725502rilles
rills55032712rills
rime65138892rime_
rimed84826372rimed
rimer75429242rimer
rimers84522552rimers
rims65936312ri_ms
rinds64826152rinds
rings65029172rings
rinks94827102rinks
rins46153202ri_ns
rinse54820972rinse
rinses64720382rinses
riots54922012riots
ripe66038932ripe_
riped85226432riped
ripen75619262ripen
ripens85012172ripens
riper74328402riper
ripest84317942ripest
rips66237442ri_ps
rise45945242rise_
risen54621882risen
riser55431052riser
risers64624782risers
risks94917062risks
risus54216392risus
rite45849462rite_
ritzes154812942ritzes
rive75537732rive_
rived94825612rived
riven85121622riven
river85731692river
rivers94626542rivers
rivet85636362rivet
rivets94417112rivets
robe65335642robe_
robed85323732robed
robles85321692robles
robs65837872rob_s
rodes614039082rodes
roes45954142r_oes
roles56747982roles
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
rube65532012rube_
rubel75416832rubel
rubels84112992rubels
rubies84420342rubies
rubles83921702rubles
rubs66133492rub_s
rubus76415062rubus
rues46044482r_ues
rules55234252rules
runes55530222runes
ruses56136582ruses
ryes75529352r_yes
rykes125513032rykes
sabes76437462sabes
scribes113713202scribes
sibbs96211902sibbs
sibs65933552sib_s
sices75637272sices
sides65838372sides
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sires55945372sires
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
tabes76033922tabes
tides64830162tides
ties45248322ti_es
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tires55437492tires
tribe74420272tribe_
trices84826332trices
tries55742812tri_es
trikes105419492trikes
trines64132562trines
tripes85324872tripes
tubes74826452tubes
urines64724122urines
vibe95124512vibe_
vices105725532vices
vies75238632vi_es
vines85137642vines
vires84529682vires
vises84427772vises
wides94832832wides
wifes114522562wifes
wiles85437872wiles
wines85546862wines
wipes104827082wipes
wires86034912wires
wises85633192wises
wites85536962wites
wives115328922wives
wizes174723342wizes
wries85827742wri_es
writes94420332writes
yikes125117752yikes
yipes106017842yipes
zibet16419732zibet
zibets1737742zibets
zines145232652zines

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.310576422.6
2DLD Change Limit538003461.64332745.0
3Display Results3463460.0933720.4
 (SQL Overall)1786913462.04687336.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.