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 “capelans” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
capelans123801(None) 
capelan1139011capelan_
capelins12311131capelins
callans94518472ca_llans
capelets1268602capelets
capelin11510972capelin_
caplins113515992cap_lins
capstans1257242capstans
captans111612052cap_tans
caterans10313222caterans
gamelans11115852gamelans
akelas10311193_akela_s
alans55636173_a__lans
cabalas113516003cabala_s
cabezons2144553cabezons
cadelles1139973cadelles
caesars9410733ca_esars
caftans12179443ca_ftans
cageling12310843cageling
cagelings1335413cagelings
caimans113811783ca_imans
calesas9411833calesa_s
callan83619603ca_llan_
callant94121223ca_llant
callants104112143ca_llants
callas84526753ca_lla_s
camelias12510313camelias
camelids1356943camelids
camels105217083camel__s
cameras11313363camera_s
cancans11311873ca_ncans
candelas1139533candela_s
canellas10310563canellas
cannelons1145213cannelons
canolas9313993canola_s
canulas9312863canula_s
capelet11517073capel_et
capellini1345283capellini
caperers122611723caperers
capering132414963capering
capers105428143cape__rs
capes95441923cape___s
capeskins1744073capeskins
capias10318353cap_ia_s
capitals12209453capitals
capless114312763cap_less
caplets114914523cap_lets
caplin103216303cap_lin_
capons104119503cap__ons
caporals1238923caporals
capstan1137913capstan_
captains121810573captains
captan101613343cap_tan_
captions123813223captions
caravans1338623caravans
careens94514703care_ens
careless102813633careless
carlins93921923ca_rlins
carnelians1244243carnelians
carpels115315463carpel__s
caseins93115053case_ins
caseloads1244283caseloads
caserns94711223case_rns
castellans1243583castellans
catclaws1543633catclaws
catenas9313113catena_s
cateran9313773cateran_
catlins93818843ca_tlins
caveats1239803cave_ats
caveman1437073caveman_
caverns124510253cave_rns
caymans14349513ca_ymans
chapeaus1544993chape_aus
chapels14429153chapel__s
chaperons1646893chaperons
chaplains1645743chap_lains
chatelains1544803chatelains
chelas113817203c_hela_s
cipolins1238033cipolins
clans75031013c___lans
cleans85817053c_le_ans
copens106119963cope__ns
copulas113811573copula_s
courlans10117613courlans
crapolas1247403crapola_s
cupelers1266733cupelers
cupeling1338863cupeling
cupels10310203cupel__s
cupolas11277753cupola_s
cyprians1544213cyprians
elans55527753___elans
favelas1337023favela_s
gamelan10106653gamelan_
japans1539823jap__ans
javelins18277733javelins
lallans74113543la_llans
lapels83712043lapel__s
paeans85118263pa_e_ans
paesans93312693pa_esans
pampeans1444703pampe_ans
paphians1545593paphians
peans75437643__pe_ans
pecans101515833__pecans
pekans121710553__pekans
plans75731273__p_lans
preplans1249613preplans
raglans82410133ra_glans
ravelins113011603ravelins
replans92814943rep_lans
scalepans1343823scalepans
scapulars1343883scapulars
scapulas1246143scapula_s
speans85417143_spe_ans
tapeless10218643tapeless
tapeline10310363tapeline
tapelines1138463tapelines

Search took 8 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621167.34619896.8
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.79822915.0
 
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.