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

141 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
caphs12451537(None) 
capes95441921capes
caph116623291caph_
capos94826071capos
caps87147891cap_s
kaphs144911501kaphs
aahs716428562_aahs
ahs68644822_a_hs
apes66047432_apes
aphis105917132_aphis
apos65433822_apos
apps86319692_apps
baps86040842bap_s
baths105922922baths
cabs86739422ca_bs
cacas95627982cacas
cache125122482cache
caches137926912caches
cades85440732cades
cadis84428492cadis
cads76144522ca_ds
cafes106426922cafes
caffs135417372caffs
cages85936012cages
caids85226422caids
cains75334302cains
cakes116037672cakes
calfs104919382calfs
caliphs1436752caliphs
calks115421602calks
calls75634732calls
calms95222352calms
calos74431902calos
camas96333522camas
cames97047312cames
camos95927612camos
campos125217952campos
camps116330262camps
campus125213922campus
cams87047282ca_ms
canes75350372canes
cans65050842ca_ns
cants77036942cants
cap76758982cap__
cape87242782cap_e
caped104931802caped
caper94831622caper
capers105428132capers
capias10318352capias
capiz18514562capiz
capo85829212cap_o
capon95221872capon
capons104119502capons
capris10415072capris
caput9823972caput
carbs96031462carbs
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carns75937562carns
carps96932252carps
carpus105514302carpus
carrs75730852carrs
cars67364762ca_rs
carts78946292carts
casas75327842casas
cases75048382cases
cash96636282cash_
cashes114729882cashes
casks115720062casks
casts77237792casts
casus76419252casus
cates75951872cates
cats66356342ca_ts
cauls75727772cauls
caves105639702caves
caws96036102ca_ws
cays95437672ca_ys
cepes94424462cepes
ceps86125952cep_s
chapes135421872chapes
chaps125326062chap_s
clachs133511322clachs
claps95626182clap_s
coapts104614002coapts
copes97747102copes
cops86751372cop_s
crapes104727692crapes
craps95328642crap_s
cups85430822cup_s
dahs88231812da_hs
daps77239162dap_s
gapes86030822gapes
gaps76042972gap_s
graphs124510152graphs
hahs108333362ha_hs
haps96443462hap_s
japes146322822japes
kapas116021732kapas
kaph135815752kaph_
khaphs18394322khaphs
kophs145010932kophs
lakhs125210342lakhs
lapis76223152lapis
laps66848872lap_s
laths86022402laths
machs125722562machs
maps86141042map_s
maths105624022maths
napas75924352napas
napes74828462napes
naps66238582nap_s
oaths86117312oaths
opahs105411982opahs
ouphs104311272ouphs
papas94927492papas
paps86443452pap_s
paths105521382paths
qophs19507812qophs
ralphs1135372ralphs
rapes75740722rapes
raphe104916422raphe
raphes115117452raphes
raphis114014322raphis
raps66247732rap_s
saps65346372sap_s
scapes105122262scapes
scarphs14437412scarphs
sophs104916022sophs
staphs114411032staphs
syphs13519452syphs
tachs105820932tachs
tapas74627712tapas
tapes75838602tapes
tapis75028862tapis
taps66050672tap_s
tophs105220052tophs
waps96642082wap_s
yaps95933522yap_s
zaps156826892zap_s

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.0931921408.6
2DLD Change Limit538001412.48621641.2
3Display Results1411410.0761855.3
 (SQL Overall)1786911412.65567303.6
 
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.