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

191 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
capos9482607(None) 
apos65433821_apos
calos74431901calos
camos95927611camos
campos125217951campos
capes95441921capes
caphs124515371caphs
capo85829211capo_
capon95221871capon
capons104119501capons
caps87147891cap_s
abos67734412_abos
ados57633512_ados
apes66047432_apes
apo511142122_apo_
apod78123182_apod
apods86316342_apods
apps86319692_apps
avos77227012_avos
baps86040842bap_s
cabob114616812cabob
cabobs124311892cabobs
cabs86739422ca_bs
cacaos104616182cacaos
cacas95627982cacas
cades85440732cades
cadis84428502cadis
cads76144522ca_ds
cafes106426922cafes
caffs135417372caffs
cages85936012cages
cahow135110942cahow
cahows14399122cahows
caids85226422caids
cains75334302cains
cajon144513902cajon
cakes116037672cakes
calfs104919382calfs
calks115421602calks
calls75634732calls
calms95222352calms
calo64936442calo_
camas96333522camas
cameos105818002cameos
cames97047312cames
camo85731752camo_
campo115219762campo_
camps116330262camps
campus125213922campus
cams87047282ca_ms
canes75350372canes
canoe75627252canoe
canoes84725882canoes
canon74725302canon
canons85522062canons
cans65050852ca_ns
canso75019402canso
cansos84915382cansos
cantos84826972cantos
cants77036942cants
cap76758982cap__
cape87242782cap_e
caped104931802caped
caper94831622caper
capers105428142capers
caph116623292cap_h
capias10318352capias
capiz18514562capiz
capote10315732capote
capotes11314642capotes
capris10415082capris
captor104914602captor
captors113914982captors
caput9823982caput
carbos105122262carbos
carbs96031462carbs
cards85137932cards
cares77369182cares
cargos94619182cargos
carks115534212carks
carls77037422carls
carns75937562carns
carob95325222carob
carobs104818102carobs
carol75128612carol
carols85124982carols
carom95025562carom
caroms105619572caroms
carps96932252carps
carpus105514302carpus
carrs75730852carrs
cars67364762ca_rs
carts78946292carts
casas75327842casas
cases75048382cases
casks115720062casks
casts77237792casts
casus76419252casus
cates75951892cates
cats66356342ca_ts
cauls75727772cauls
caves105639702caves
caws96036112ca_ws
cays95437672ca_ys
cepes94424462cepes
ceps86125952cep_s
ceros74726072ceros
chaos105622862chaos
chapes135421872chapes
chaps125326062chap_s
cheapos14418512cheapos
chops125019872chops
claps95626182clap_s
claros84015112claros
clops95924852clops
coapts104614012coapts
cocos95624692cocos
cohos105921852cohos
compos124818802compos
coops96229642coops
coos67456492c_oos
copes97747102copes
cops86751372cop_s
cos510270392c__os
crapes104727692crapes
craps95328642crap_s
crops96125232crops
cups85430822cup_s
dados75522432dados
dagos76419442dagos
daps77239162dap_s
datos65222782datos
epos66723732_epos
expos1449202expos
fados95620732fados
fanos85926502fanos
faros85532022faros
gapes86030822gapes
gaps76042972gap_s
halos85230252halos
haps96443462hap_s
hypos1312014742hypos
japes146322822japes
jatos125116822jatos
kapas116021732kapas
kaphs144911502kaphs
kapok10448782kapok
kapoks11347262kapoks
kayos127714702kayos
lapis76223152lapis
laps66848872lap_s
makos116518362makos
manos74933622manos
maps86141052map_s
mayos105521932mayos
naos47429732na_os
napas75924352napas
napes74828462napes
naps66238582nap_s
papas94927492papas
paps86443452pap_s
pepos96620082pepos
rapes75740722rapes
raps66247732rap_s
ratos55528762ratos
repos74725792repos
sagos66123872sagos
sapor75119252sapor
sapors84118812sapors
saps65346372sap_s
saros55238062saros
scapes105122262scapes
scapose1147752scapose
tacos77023552tacos
taos45541002ta_os
tapas74627712tapas
tapes75838602tapes
tapis75028862tapis
taps66050682tap_s
taros55640822taros
topos75726392topos
typos106015812typos
vapor104013092vapor
vapors113812692vapors
waps96642082wap_s
yapok14468152yapok
yapoks15346782yapoks
yapon104613582yapon
yapons114411772yapons
yaps95933522yap_s
zaps156826892zap_s

Search took 7 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 Filter178691538001.186150666.9
2DLD Change Limit538001915.28010189.4
3Display Results1911910.346552.0
 (SQL Overall)1786911916.81226231.8
 
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.