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

194 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
charpoy173571(None) 
charpoys1834531charpoys
carboy134914182c_arboy
champy18509612champ_y
charily15310282charily
chariot12316212chariot
charity15311022charity
charley15118272charley
charpai1436632charpai
charro114212952charro_
charros124312142charros
charry145012112char_ry
chary135023132char__y
chirpy16498912chirp_y
harpy136418212_harp_y
sharply15406832sharply
sharpy145211032sharp_y
campo115219763c_ampo_
campos125217953c_ampos
campy145116183c_amp_y
canopy1337733c_anopy
capo85829213c_a_po_
capon95221873c_a_pon
capos94826073c_a_pos
carbo94923843c_arbo_
carbon104919043c_arbon
carbos105122263c_arbos
carboys144711783c_arboys
cardon94120853c_ardon
cargo85322073c_argo_
cargos94619183c_argos
carhop133610763c_arhop
carney115315703c_arney
carny105822923c_ar_ny
carob95325223c_ar_ob
carol75128613c_ar_ol
carom95025563c_ar_om
carp85139813c_arp__
carpal103716253c_arpal
carped115923763c_arped
carpel105418473c_arpel
carper104923633c_arper
carpet104530093c_arpet
carpi94319393c_arp_i
carpool1139223c_arpool
carport11316033c_arport
carps96932253c_arp_s
carpus105514303c_arpus
carrom10513403c_arrom
carrot8423123c_arrot
carroty1248943c_arroty
carry105823783c_ar_ry
carton84522663c_arton
cartop104213563c_artop
chador1238673cha_dor
chaebol1444943chaebol
chaffy20456473cha_ffy
chalky18468773cha_lky
challot123613263challot
chally144314293cha_lly
chalot113020133cha_lot
chammy18488953cha_mmy
champ145017963champ__
champac1834953champac
champak2034493champak
champed174111483champed
champer163813413champer
champion17276353champion
champs154915683champ_s
chancy164010863cha_ncy
chanoyu1544483cha_noyu
chanson1238043chanson
chantey154112543chantey
chantor123710313chantor
chantry15388223chantry
chanty145215823cha_nty
chao95727313cha__o_
chaos105622863cha__os
chap114928493cha_p__
chape125221143cha_p_e
chapel134911373cha_pel
chapes135421873cha_pes
chapped172711443chapped
chappie16298663chappie
chaps125326063cha_p_s
chapt125827643cha_p_t
char95132153char___
charade13129913charade
charas114223613char_as
charcoal15165743charcoal
charcoaly19153173charcoaly
chard116124743char__d
chards125119733char_ds
chare105231983char__e
chared125423693char_ed
chares115631803char_es
charge125114213char_ge
charged144614023charged
charger133914063charger
charges134615983charges
charier124317903charier
charing133721323charing
chariots1339393chariots
charism14712203charism
chark144222713char__k
charka154011703char_ka
charkas164810963charkas
charked174814013charked
charkha19405153charkha
charks155219703char_ks
charlady1743403charlady
charleys1695633charleys
charlie123011923charlie
charlock1944393charlock
charm126124663char__m
charmed154714253charmed
charmer144913663charmer
charms135218843char_ms
charnel124010053charnel
charpais1536933charpais
charqui2144003charqui
charr104821783char__r
charred134614483charred
charrs115219193char_rs
chars105936643char__s
chart105038283char__t
charted135116853charted
charter123918303charter
charts115823093char_ts
chasmy16468543cha_smy
chatroom1596263chatroom
chatty14419363cha_tty
chay124924873cha___y
cheaply1735023cheaply
cheapo134810083cheapo_
cheapos14418513cheapos
cheroot12413693cheroot
cherry144810763cher_ry
cherty144612473cher_ty
chippy18437613ch_ippy
chiro105320343chir_o_
chiropody2053093chiropody
chiros114617773chir_os
chirp124717163chirp__
chirped15379783chirped
chirper14359963chirper
chirpily1843773chirpily
chirps135414003chirp_s
choirboy1842233choirboy
choppy18376293ch_oppy
chorion12311773chorion
chromy16309903ch_romy
churchy2044183churchy
churro11448353churro_
churros12427583churros
clarify1536093clarify
clarion9311663clarion
clarity12310913clarity
claro75018693clar_o_
claros84015113clar_os
clary105719613clar__y
crampon1336943crampon
crampy154710993cramp_y
crappy15446803cra_ppy
czardom2144183czardom
gharry13546273ghar_ry
haply135915063_ha_ply
happy155813533_ha_ppy
harbor11410723_harbor
hardly135112833_hardly
hardy125622063_har_dy
harlot94422803_harlot
harmony1538173_harmony
harp96134293_harp__
harped124418403_harped
harper115018403_harper
harpin113614383_harpin
harpoon1238313_harpoon
harps105926873_harp_s
harrow122610773_harrow
harry115322953_har_ry
pharaoh1545033pharaoh
pharos11312063phar_os
shamoy14379913sha_moy
shampoo1435373shampoo
sharny124711833shar_ny
sharp104922533sharp__
sharped134112053sharped
sharpen12389723sharpen
sharper124312703sharper
sharpie1238403sharpie
sharps115516083sharp_s
tarpon82812803_tarpon
teapoy1138113tea_poy

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271946.61020276.4
3Display Results1941940.0633079.4
 (SQL Overall)1786911947.06325299.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.