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

125 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
charpoys183453(None) 
charpoy1735711charpoy_
carboys144711782c_arboys
chariots1339392chariots
charleys1695632charleys
charpais1536932charpais
charros124312142charro_s
acarpous1245313acarpous
campos125217953c_ampo_s
capons104119503c_a_pons
capos94826073c_a_po_s
carbons115418943c_arbons
carbos105122263c_arbo_s
carboy134914183c_arboy_
cardons104519933c_ardons
cargoes104415223c_argoes
cargos94619183c_argo_s
carhops14329703c_arhops
carious93320283c_arious
carneys124310543c_arneys
carobs104818103c_ar_obs
carols85124983c_ar_ols
caroms105619573c_ar_oms
carpals113414623c_arpals
carpels115315463c_arpels
carpers114521253c_arpers
carpets113915333c_arpets
carpool1139223c_arpool
carpools1237883c_arpools
carport11316033c_arport
carports1238943c_arports
carps96932253c_arp__s
carpus105514303c_arp_us
carroms11512403c_arroms
carrots9714623c_arrots
cartons94122473c_artons
chadors1338753cha_dors
chaebols1544723chaebols
chamois143512193cha_mois
champacs1934633champacs
champaks2134103champaks
champers173311623champers
champions18875783champions
champs154915683champ__s
champy18509613champ_y_
chanoyu1544483cha_noyu
chanoyus1643923cha_noyus
chansons1337473chansons
chanteys16387493chanteys
chantors133710263chantors
chaos105622863cha__o_s
chapels14429153cha_pels
chapes135421873cha_p_es
chappies172610093chappies
chaps125326063cha_p__s
charades141310853charades
charas114223613char__as
charases131312763charases
charcoal15165743charcoal
charcoals16174683charcoals
chards125119733char__ds
chares115631803char__es
chargers144011323chargers
charges134615983char_ges
charily15310283charily_
chariot12316213chario_t
charisms15710263charisms
charity15311023charity_
charkas164810963char_kas
charkhas20285023charkhas
charks155219703char__ks
charley15118273charley_
charlies133414233charlies
charlock1944393charlock
charlocks2044073charlocks
charmers154211333charmers
charms135218843char__ms
charnels13328173charnels
charpai1436633charp_ai
charquis2243933charquis
charro114212953charro__
charrs115219193char__rs
charry145012113char_ry_
chars105936643char___s
charters134115583charters
charts115823093char__ts
chary135023133char__y_
chatrooms1685103chatrooms
chays135319743cha___ys
cheapos14418513cheapo_s
cheroots1348193cheroots
chiros114617773chir_o_s
chirpers15358133chirpers
chirps135414003chirp__s
chirpy16498913chirp_y_
choirboys1941903choirboys
chorions13310663chorions
churros12427583churro_s
clarions10310493clarions
claroes93113733clar_oes
claros84015113clar_o_s
crampons1436643crampons
czardoms2243743czardoms
harbors12412413_harbors
harlots103413293_harlots
harpers124916203_harpers
harpies123818313_harpies
harpins123615703_harpins
harpoon1238313_harpoon
harpoons1337483_harpoons
harps105926873_harp__s
harpy136418213_harp_y_
harrows132611033_harrows
pharaohs1644493pharaohs
pharos11312063phar_o_s
shamoys15367283sha_moys
shampoos1544603shampoos
sharpens13377813sharpens
sharpers133810943sharpers
sharpies13411223sharpies
sharply15406833sharply_
sharps115516083sharp__s
sharpy145211033sharp_y_
tarpons92612213_tarpons
teapoys1235963tea_poys

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.436409841.7
2DLD Change Limit1461621257.00020880.3
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.48223882.8
 
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.