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

124 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
carols8512498(None) 
carls77037421car_ls
carobs104818101carobs
carol75128611carol_
caroli85918231caroli
carolus94612601carolus
caroms105619571caroms
parols84722611parols
across8312642across
argols74514612_argols
arils58732202_arils
aryls87015812_aryls
awols84713522_awols
barons85025382barons
cabals104020152cabals
cabobs124311892cabobs
cahows14399122cahows
cajole154011182cajole
cajoles163712102cajoles
calls75634732ca_lls
calos74431902calo_s
camels105217082camels
camos95927612camo_s
canals84421662canals
canoes84725882canoes
canola8313622canola
canolas9313992canolas
canons85522062canons
capons104119502capons
capos94826072capo_s
caracols12310412caracols
carats85929022carats
carbons115418942carbons
carbos105122262carbos
carboys144711782carboys
carbs96031462car_bs
carcels114516062carcels
cardons104519932cardons
cards85137932car_ds
carers85133952carers
cares77369182car_es
caress85720262caress
carets85330772carets
carfuls1249132carfuls
cargoes104415222cargoes
cargos94619182cargos
carhops14329702carhops
caries85147622caries
cariole9818342cariole
carioles10817062carioles
carious93320282carious
carks115534212car_ks
carl65144782car_l_
carle74535702car_le
carles85435082carles
carns75937562car_ns
carob95325222caro_b
caroch13911762caroch
caroled103717682caroled
caroler93816752caroler
carolers103314172carolers
carom95025562caro_m
carouse9614422carouse
carpals113414622carpals
carpels115315462carpels
carpools1237882carpools
carps96932252car_ps
carpus105514302carpus
carrels95117302carrels
carroms11512402carroms
carrots9714622carrots
carrs75730852car_rs
cars67364762car__s
carses85233652carses
cartels94618122cartels
cartes86239472cartes
cartons94122472cartons
carts78946292car_ts
carvels124914592carvels
carves115128452carves
cauls75727772ca_uls
cavils114014392cavils
ceorls848162ceorls
ceros74726072cero_s
cerous85821202cerous
cibols1039522cibols
claroes93113732claroes
claros84015112claro_s
cols66553082c__ols
cools75632632c_ools
corals85325142corals
craals84113302craals
crawls114712082crawls
crocs95722432c_rocs
crops96125232c_rops
cross75124502c_ross
crows105727312c_rows
curls74927102cur_ls
cymols1377192cymols
earls56127512ear_ls
enrols61213382enrols
farls85731112far_ls
faros85532022faro_s
gaols66717572ga_ols
harls85634502har_ls
jarls126120962jar_ls
karoos102415802karoos
kaross101910012kaross
marls75535162mar_ls
nerols6914882nerols
parol74826272parol_
parole84425252parole
paroles95025882paroles
parous84024162parous
patrols93513512patrols
safrols1036862safrols
salols64017872salols
sarods74918572sarods
saros55238062saro_s
tarocs84615662tarocs
taroks106115282taroks
taros55640822taro_s
tarots66422992tarots
taxols13328632taxols

Search took 4 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.1261418182.5
2DLD Change Limit825511242.95327955.0
3Display Results1241240.0462695.7
 (SQL Overall)1786911243.12557181.1
 
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.