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 “chaplain” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
chaplain154619(None) 
chaplains1645741chaplains
calpain11310412c_alpain
caplin103216302c_apl_in
captain112111062c_aptain
chaplaincy2251352chaplaincy
chapman1637892chapma_n
chatelain1445002chatelain
complain1448762complain
calkin123515493c_a_lkin
callan83619603c_alla_n
calpains1239763c_alpains
capelan1139003c_apela_n
capelin11510973c_apelin
caplins113515993c_apl_ins
captains121810573c_aptains
captan101613343c_apta_n
carlin84421823c_arl_in
catlin83819083c_atl_in
chablis14368563chabl_is
chagrin1337893cha_grin
chain105723673ch___ain
chalah143511663cha_la_h
chalahs15289883cha_lahs
chalaza2145733cha_laza
chalazia2245133cha_lazia
chalazion23113723cha_lazion
chalcid1537883cha_lcid
chalking183310063cha_lking
challa114014193challa__
challah15458323challa_h
challahs16377563challahs
challas124414123challa_s
challie124012853cha_llie
challis124613463cha_llis
chamfrain1943363chamfrain
champaign1942473champaign
chapati14118023chap_ati
chapatis15127943chapatis
chapeau1435523chapea_u
chapeaus1544993chapeaus
chapeaux2242523chapeaux
chaperon1547353chaperon
chaplet14512253chapl_et
chaplets1556883chaplets
chapmen1637283chap_men
chappati17124013chappati
chappatis18114013chappatis
chappie16298653chap_pie
chapping183710723chap_ping
characin1547993characin
charlady1743403charlady
charlatan1443543charlatan
charlie123011923charl_ie
charpai1436633charpai_
charpais1536933charpais
chatelaine1544303chatelaine
chatelains1544803chatelains
chazan20269133cha_za_n
chazzan20204853chazza_n
chilblain1693193chilblain
chitlin12269283chitl_in
chopin132712193chop__in
cisplatin1344713cisplatin
coalbin1137533coa_lbin
cocaptain1543663cocaptain
complains1549193complains
complaint15410253complaint
complin13312073compl_in
explain1667043_explain
graplin1058443grapl_in
haploid1339833_haploid
papain10313793_pap_ain
plain74823303___plain

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.440406115.9
2DLD Change Limit146162746.95321021.4
3Display Results74740.0302466.7
 (SQL Overall)178691747.42324072.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.