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

226 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
cauls7572777(None) 
calls75634731calls
carls77037421carls
caul65630001caul_
cauld85318441cauld
caulds95512381caulds
caules85927251caules
caulis85320081caulis
caulk115315451caulk
caulks125611861caulks
hauls86123731hauls
mauls76524951mauls
sauls55128121sauls
wauls86120551wauls
aals49941142_aals
acyls104211522acyls
ails45654712_ails
alls46740922_alls
als36663022_a_ls
auks85525262_auks
auld54125362_auld
awls75926092_awls
baals76122702baals
babuls105413642babuls
bails75933522bails
balls76236412balls
bals66354042ba_ls
bauds85821042bauds
baulk114914332baulk
baulks12429372baulks
bawls105719322bawls
cabals104020152cabals
cable95329912cable
cables104527552cables
cabs86739422ca_bs
cacas95627982cacas
cades85440732cades
cadis84428502cadis
cads76144522ca_ds
cafes106426922cafes
caffs135417372caffs
cages85936012cages
caids85226422caids
cains75334302cains
cakes116037672cakes
calf96339562ca_lf
calfs104919382calfs
calk105527662ca_lk
calks115421602calks
call66838672ca_ll
calla74827072calla
callas84526752callas
callus85317072callus
calm85032362ca_lm
calms95222352calms
calo64936442ca_lo
calos74431902calos
calx135722792ca_lx
camas96333522camas
camels105217082camels
cames97047312cames
camos95927612camos
camps116330262camps
cams87047282ca_ms
canals84421662canals
canes75350372canes
canfuls1248422canfuls
cans65050852ca_ns
cants77036942cants
canula8312962canula
canulas9312852canulas
capes95441922capes
capfuls1436522capfuls
caphs124515372caphs
capos94826072capos
caps87147892ca_ps
carbs96031462carbs
cards85137932cards
cares77369182cares
carfuls1249132carfuls
carks115534212carks
carl65144782carl_
carle74535702carle
carles85435082carles
carns75937562carns
carols85124982carols
carps96932252carps
carrs75730852carrs
cars67364762ca_rs
carts78946292carts
casas75327842casas
cases75048382cases
casks115720062casks
casts77237792casts
casuals91410522casuals
casus76419252casus
cates75951892cates
cats66356342ca_ts
caucus1039612caucus
caudle93912912caudle
caudles103912812caudles
causals91411182causals
cause75225352cause
causes88026472causes
caves105639702caves
cavils114014392cavils
caws96036112ca_ws
cays95437672ca_ys
ceils75019402ceils
cells75428062cells
cels65534972c_els
chubs125412622chubs
chugs115511942chugs
chums125015832chums
churls115411072churls
clubs95415102clubs
clues74623032clues
coals76129602coals
coils75030082coils
cols66553082c_ols
cools75632632cools
could86517712could
coulis84018762coulis
coups95522472coups
cowls106922212cowls
craals84113302craals
crawls114712082crawls
cruds85815852cruds
crus65828482cru_s
cubs85832382c_ubs
cuds76730472c_uds
cues65438982c_ues
cull65929642c_ull
culls75425812culls
culm85822382c_ulm
culms95314192c_ulms
cult66541152c_ult
cults75022552c_ults
cups85430822c_ups
curls74927102curls
curs65645542c_urs
cuss65430612c_uss
cuts65841152c_uts
dahls95012282dahls
dals57145122da_ls
daubs85014562daubs
dauts67822242dauts
duals65620082duals
earls56127512earls
fails85631482fails
falls85727652falls
farls85731112farls
fauld95214492fauld
faulds10438962faulds
fault85428312fault
faults94513552faults
fauns84516752fauns
fouls87221432fouls
galls64729322galls
gals57946502ga_ls
gaols66717572gaols
gauds75717722gauds
gault65128482gault
gaults74112782gaults
gaums86217072gaums
gaurs66317992gaurs
gauss65613452gauss
guls55930852_guls
hails85231642hails
halls85633782halls
harls85634502harls
haul75530452haul_
haulm104415412haulm
haulms11558502haulms
jails125422942jails
jarls126120962jarls
jauks165412462jauks
jaups144810532jaups
kails95525212kails
lalls55324132lalls
lauds65618482lauds
mails76037782mails
malls76233432malls
marls75535162marls
mauds85519272mauds
maul64830722maul_
mauts75927192mauts
miauls8178712miauls
nails55730402nails
pails75833062pails
palls74332562palls
pals66951352pa_ls
pawls105617662pawls
puls65437562_puls
rails55937402rails
sails55738102sails
sals46851672sa_ls
saul45836522saul_
sault55834962sault
saults65816172saults
scalls84218202scalls
scaups105411932scaups
scaurs85512052scaurs
schuls11299852schuls
shauls94913112shauls
shuls85319712shuls
souls55127362souls
taels56822072taels
tails55634192tails
talls55133432talls
talus55423262talus
taus46342732tau_s
tauts56125512tauts
vails85825932vails
vault85823762vault
vaults94511672vaults
vaus75928922vau_s
wails86631482wails
walls85529382walls
wauks125515162wauks
waul76927312waul_
wawls115416472wawls
yauds95013222yauds
yauld95511182yauld
yaups105910742yaups
yawls114613602yawls

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.1101624463.6
2DLD Change Limit538002261.75030742.9
3Display Results2262260.0633587.3
 (SQL Overall)1786912261.92392923.0
 
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.