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

162 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
cavies11452500(None) 
caries85147621caries
caves105639701cav_es
cavie104621591cavie_
cavils114014391cavils
civies114116441civies
davies105020511davies
mavies114923191mavies
navies95218621navies
wavies125019841wavies
amies76837692_amies
aves76142602_av_es
babies106123652babies
bevies114017302bevies
cabbies133115162cabbies
cabins104418922cabins
cables104527552cables
caches137926912caches
caddies113718382caddies
cades85440732ca_des
cadges104716712cadges
cadis84428502cadi_s
cadres94017932cadres
cafes106426922ca_fes
cages85936012ca_ges
cagier93715932cagier
cagiest102916432cagiest
cahier113615772cahier
cahiers123510672cahiers
caids85226422ca_ids
cains75334302ca_ins
cakes116037672ca_kes
cakier123115242cakier
cakiest133215662cakiest
calces104420052calces
calices114321692calices
califs114915892califs
calves115119282calves
calxes154113032calxes
cames97047312ca_mes
camise103319632camise
camises114218462camises
cammies134016482cammies
candies104125612candies
canes75350372ca_nes
canids95118132canids
canines93724032canines
canoes84725882canoes
capes95441922ca_pes
capias10318352capias
capizes20410372capizes
cares77369182ca_res
caribes113715642caribes
carices114220952carices
caried94528692caried
carles85435082carles
carnies94123962carnies
carries94328012carries
carses85233652carses
cartes86239472cartes
carves115128452carves
cases75048382ca_ses
cashes114729882cashes
castes85631862castes
cates75951892ca_tes
catties94023052catties
caules85927252caules
causes88026472causes
cave95941262cav_e_
caved116227562cav_ed
caver105629062cav_er
cavers115026842cavers
caviar11310162caviar
caviares1337992caviares
caviars1238622caviars
cavil103816492cavi_l
caviled1348722caviled
caviler1249062caviler
cavilers1348112cavilers
caving124822612caving
cavings134712542cavings
cavities131412612cavities
cavity14310012cavity
chevies153511442chevies
chives144317592chives
chivies153412852chivies
cities84524852cities
civics13397822civics
civie103716352civie_
civvies1555842civvies
claries93422202claries
claves115020062clav_es
clavier1239172clavier
claviers1367102claviers
colies84837052colies
conies84338592conies
copies104130302copies
cosies84932152cosies
coves105539172cov_es
covins114618062covins
cozies174521412cozies
craves115825392crav_es
crazies183413852crazies
cries75438402c_ries
curies84934022curies
cuties84927362cuties
cuvees1139372cuvees
davits104012362davits
easies64126632easies
eaves85231992eav_es
envies9314052envies
facies113921592facies
faves115331422fav_es
gabies93820732gabies
gravies11314092gravies
haves116034872hav_es
heavies132713872heavies
ivies84215762_ivies
ladies75124882ladies
laves86039152lav_es
lazies154418782lazies
levies93919862levies
mamies104626242mamies
mavie104722562mavie_
mavins115119182mavins
mavis105622722mavi_s
mavises122812992mavises
movies115118452movies
naives94914222naives
naves87030382nav_es
navvies1335322navvies
oaves84925612oav_es
paries84742512paries
paves104833922pav_es
pavins114919662pavins
pavis106422732pavi_s
pavise114714802pavise
pavises125315492pavises
peavies122213402peavies
rabies85226022rabies
ramies84630462ramies
raves85441972rav_es
ravines104220232ravines
ravins94622562ravins
sanies63031952sanies
saves85838632sav_es
savines104417632savines
savins93923132savins
savvies1337602savvies
scabies11613332scabies
shavies134213212shavies
spavies123012952spavies
taxies135817332taxies
varies94330872varies
vies75238622__vies
wadies105121202wadies
waives123714182waives
walies95324522walies
waves115633922wav_es
wavier124613082wavier
waviest134513072waviest
zanies153219672zanies

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 Filter178691825510.343520965.0
2DLD Change Limit825511622.26636430.3
3Display Results1621620.0463521.7
 (SQL Overall)1786911622.65567303.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.