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

199 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
chariots133939(None) 
chariot12316211chariot_
carious93320282c_arious
carrots9714622c_arrots
chariest13315502chariest
charioted1595862charioted
charisms15710262charisms
charity15311022chari_ty
charpoys1834532charpoys
charros124312142charro_s
chartists14126802chartists
charts115823092char__ts
cheroots1348192cheroots
cheviots1643782cheviots
chorions13310652chorions
clarions10310492clarions
czarists1966222czarists
haricots1347332_haricots
harlots103413292_harlots
heriots10312062_heriots
argots74116023__argots
cahoots1238473c_ahoots
camions113916133c_amions
carats85929023c_ar_ats
carbons115418943c_arbons
carbos105122263c_arbo_s
carboys144711783c_arboys
cardons104519933c_ardons
carets85330773c_ar_ets
cargoes104415223c_argoes
cargos94619183c_argo_s
carhops14329703c_arhops
caribes113715643c_aribes
caribous1258823c_aribous
carices114220953c_arices
caries85147623c_ari_es
carinas93622383c_arinas
carioca1139683c_arioca
cariocas1239663c_ariocas
cariole9818343c_ariole
carioles10817063c_arioles
caritas93316943c_aritas
carnets93918403c_arnets
carobs104818103c_ar_obs
carols85124983c_ar_ols
caroms105619573c_ar_oms
carpets113915333c_arpets
carports1238943c_arports
carrions10312443carrions
carroms11512403c_arroms
carrot8423123c_arrot_
carroty1248943c_arroty
cartons94122473c_artons
carts78946293c_ar__ts
cations94524143c_ations
chadors1338723cha_dors
chaebols1544723chaebols
chagrins1437063chagri_ns
chaines124518733cha_ines
chains114819703cha_i_ns
chairlifts1851313chairlifts
chairs114916173cha_i_rs
chais107530313cha_i__s
chaises124317493cha_ises
chalets122813473cha_lets
chalices15310813chalices
challot123613263challot_
challoth16316103challoth
chalot113020133cha_lot_
chaloth15298603cha_loth
chamisas15317793chamisas
chamises153513313chamises
chamisos15307423chamisos
chamois143512173cha_mois
champions18875783champions
chansons1337473chansons
chantors133710253chantors
chants115020393cha__nts
chaos105622863cha__o_s
chaplets1556883chaplets
charades141310843charades
charas114223593char__as
charases131312753charases
charcoal15165733charcoal
charcoals16174673charcoals
chards125119723char__ds
chares115631803char__es
chargers144011313chargers
charges134615983char_ges
charier124317903chari_er
charily15310283chari_ly
chariness14310063chariness
charing133721323chari_ng
charioteer1552753charioteer
charioteers1652423charioteers
charioting1645713charioting
charism14712203chari_sm
charisma1576353charisma
charismas1655293charismas
charities14312733charities
charkas164810953char_kas
charkhas20285023charkhas
charks155219703char__ks
charleys1695633charleys
charlies133414223charlies
charlock1944393charlock
charlocks2044073charlocks
charlotte1443793charlotte
charlottes1543823charlottes
charmers154211323charmers
charms135218833char__ms
charnels13328173charnels
charpais1536923charpais
charpoy1735713charpo_y
charquis2243913charquis
charriest1438253charriest
charro114212953charro__
charrs115219183char__rs
chars105936633char___s
chart105038283char__t_
charters134115563charters
chartist131112133chartist_
chasings14318253chasings
chatrooms1685103chatrooms
chats105730093cha___ts
chaunts1267083cha_unts
chayote1536493cha_yote
chayotes1636493cha_yotes
cheerios13317573cheerio_s
chemists152710323chemists
cheroot12413693cheroot_
cherts115617233cher__ts
cheviot1546933cheviot_
chints115117833ch__ints
chiros114617773chir_o_s
chits105424573ch__i_ts
chorines132917253chorines
chorioid1448323chorioid
chorioids1545663chorioids
chorion12311763chorio_n
chorizos2245483chorizos
choroids1438683choroids
chrisms1499143ch_risms
chrisoms1566093ch_risoms
christy1536623ch_risty
churros12427583churro_s
chutists1335583chutists
chymists18285603chymists
cladists1136713cladists
clarets94111103clar_ets
claries93422203clari_es
clarinets1137683clarinets
clarion9311663clario_n
clarionets1243903clarionets
clarity12310913clari_ty
claroes93113733clar_oes
claros84015113clar_o_s
cohabits1545413cohabi_ts
crits75527573c__ri_ts
curios83218333c_urio_s
curious93813563c_urious
czardoms2243743czardoms
czarinas1935293czarinas
czarisms2155753czarisms
czarist18710223czarist_
diarists9410363diarists
galiots82311323_galiots
gharials1245123gharials
griots74713643__griots
habits113014643_habi_ts
haints94417583_ha_ints
harbors12412413_harbors
haricot12311963_haricot_
harlot94422803_harlot_
harpists1338093_harpists
harrows132611033_harrows
harts88441593_har__ts
haviors1347383_haviors
heriot9422343_heriot_
lariats7615053_lariats
marmots11311513_marmots
parrots9312743_parrots
patriots1038053patriots
pharaohs1644493pharaohs
pharos11312063phar_o_s
riots54922013___riots
scarious10610203scarious
shallots11319493shallots
shariahs14206393shariahs
sharias102516003shari_as
sharifs13279903shari_fs
sheroots1137863sheroots
shrifts1335963sh_rifts
tarots66422993_tar_ots
thrifts1335523th_rifts
tsarists857303tsarists
tzarists1755693tzarists
various103113103_various
whatnots1442303whatnots

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.1561145455.1
2DLD Change Limit1461621997.43619656.0
3Display Results1991990.0762618.4
 (SQL Overall)1786911997.66823303.5
 
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.