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

153 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
coronals10331289(None) 
coronal94115761coronal_
coronas93916901corona_s
coronels104012141coronels
colonels104210452colonels
colonials1147902colonials
corals85325142cor__als
cordials1139602cordials
cornels94716662cor_nels
corollas1039202corollas
corona83817402corona__
coronach1545762coronach
coronachs1644252coronachs
coronae94214892corona_e
coronally1448412coronally
coronary1347692coronary
coronate103018212coronate
coronates1110816922coronates
coronel94515222coronel_
coroners104016222coroners
coronets103814362coronets
corporals1347272corporals
corrals93713852cor_rals
adrenals946303adrenals
ammonals1245393ammonals
borals86721913bor__als
borons85520543boron__s
borstals1037463borstals
bromals1139743_bromals
canals84421663c__anals
caporals1238923caporals
caracals12310743caracals
carbonyls1675033carbonyls
cardinals1247983cardinals
carinal94318223carinal_
carinas93622383carina_s
carnal83919203car_nal_
carols85124983caro__ls
carousals1165333carousals
carpals113414623car_pals
ceramals1246513ceramals
cereals9313173cer_eals
chlorals13148023chlorals
chorals124614103c_horals
chromas142512683chroma_s
chromyls18244733chromyls
chronaxy2343253chronaxy
chronics1538683chronics
chronons1347353chronons
clonal8310913c_lonal_
coaevals1344553coaevals
coals76129603c__o_als
cocoas104915743coco_a_s
cocomats1449403cocomats
coconuts1246323coconuts
cocoyams1743453cocoyams
codons96119463codon__s
coequals1944303coequals
coevals1237873co_evals
cognacs1256043co_gnacs
cogons96818113cogon__s
cojones163512103cojon_es
colonel94213283colonel_
colones96124433colon_es
colonial10411343colonial_
colonics123711613colonics
colonies103620013colonies
colons86028683colon__s
colonus94413443colon_us
conceals123111013conceals
confrontals1652663confrontals
congeals11309853congeals
cools75632633co_o__ls
cooncans1246273co_oncans
coons76737283co_on__s
copals105018943c__opals
coral76033453cor__al_
corantos10310103corantos
corbans11313173cor_bans
corbeils12358073corbeils
corbels113813593cor_bels
corbinas12229383corbina_s
cordial10312933cordial_
cordobas1345793cordoba_s
cordons104415763cordon__s
cordovans1543683cordovans
cormels113813373cor_mels
cornball1247053cornball
cornballs1346313cornballs
corneal94414503corneal_
corneas94716993cor_neas
cornel84020053cor_nel_
corners94723313cor_ners
cornets94820573cor_nets
cornily12410853cor_nily
cornmeals1344573cornmeals
corns76034763cor_n__s
cornual94210173cornual_
cornus84816563cor_n_us
corodies11313693corodies
corolla938623coro_lla
coronaries12410223coronaries
coronated123313323coronated
coroner94218203coron_er
coronet94227173coron_et
coronoid1148943coronoid
corotate102813933corotate
corotates112714283corotates
corporal1248513corporal_
corral83616253cor_ral_
corrivals1444603corrivals
corsacs1139013cor_sacs
cortinas102212423cortina_s
corvinas13238003corvina_s
corydalis1593483corydalis
coryzal2154813coryzal_
coryzas2134793coryza_s
craals84113303c_r_aals
crenels93711013c_renels
croaks125812983c_ro_aks
crones84729243c_ron_es
cronies9622503c_ronies
crooners103911393crooners
croons85418423croon__s
curtals93111623cur_tals
doornails1043623doornails
dorsals84110843dor_sals
ecotonal1046253ecotonal_
formals123312893for_mals
frontals1146273_frontals
goorals838703go_orals
gorals76917653gor__als
hormonal1346633hormonal_
isogonals1042953isogonals
journals1574353journals
korunas1135443koruna_s
morals85324633mor__als
morons84919543moron__s
mortals93914003mor_tals
nominals10278613nominals
normals92510903nor_mals
orals55826483_or__als
ordeals877993_ordeals
ordinals946743_ordinals
personals11238573personals
portals94015563por_tals
rorquals1773173rorquals
royals93711263__royals
seconals1047053seconals
sororal7310653sororal_
tronas63816893_trona_s
urinals7610253_urinals
zoonal1558083zo_onal_

Search took 9 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.1731032896.0
2DLD Change Limit1461621538.29617618.4
3Display Results1531530.0632428.6
 (SQL Overall)1786911538.53220943.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.