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

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

69 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
churchliest215236(None) 
churchiest2044051church_iest
churchless20112492churchl_ess
churchlier2052262churchlie_r
churchliness2251602churchliness
chichiest1936343ch_ich_iest
chinchiest2044413chinch_iest
churches1846433church__es_
churchier1944153church_ie_r
courtliest1244903cour_tliest
crunchiest1764793crunch_iest
curliest102713123c_ur__liest
bunchiest1635664_bunch_iest
burbliest1365594_bur_bliest
burliest103113064_bur__liest
catchiest1638314c_atch_iest
chanciest1638374chanc__iest
chariest13315504char___iest
charlies133414234char__lies_
charriest1438254char__riest
checklist2043854ch_eckli_st
chertiest1438794cher__tiest
childliest1653864ch_ildliest
chilliest14358914ch__illiest
chirpiest16286474chir__piest
chromiest1637784ch_r_omiest
chubbiest1843754chu__bbiest
chuckies1937704chu_c_kies_
chuckles1936804chu_ckl_es_
chuffiest2044404chu__ffiest
chummiest1834644chu__mmiest
chunkiest1835264chu__nkiest
churched1934654church__e_d
churchgoer2151704churchgoe_r
churchgoers2251554churchgoers
churching2055084church_i_ng
churchings2162554church_ings
churchlinesses2451394churchlinesses
churchly2142974churchl___y
churchmen2142924church_me_n
churlish1644904chur__li_sh
clerkliest1642794cler_kliest
couthiest1439404cou_th_iest
crackliest1844884c_rackliest
crawliest14187404c__rawliest
crumbliest1643904cru_mbliest
crumpliest1644124cru_mpliest
cuddliest1343334c_u_ddliest
curches143512744c_urch__es_
curculios1343294c_urculios_
curdiest112511394c_ur__diest
curviest13309674c_ur__viest
cushiest133411044c_u_sh_iest
earthliest1345394_earthliest
hackliest1836524_h_ackliest
hurlies103315334_hur__lies_
knuckliest1542554knu_ckliest
knurliest1344074knur__liest
paunchiest1743854paunch_iest
pouchiest1636844pou_ch_iest
punchiest1636454_punch_iest
raunchiest1543934raunch_iest
smutchiest1743264smutch_iest
starchiest1547184starch_iest
surliest82416914_sur__liest
thatchiest1844164thatch_iest
torchiest1438034_torch_iest
touchiest1437084tou_ch_iest
whirliest15216044whir__liest

Search took 10 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 Filter1786911488190.1701051123.5
2DLD Change Limit148819699.69015358.0
3Display Results69690.0302300.0
 (SQL Overall)178691699.89018067.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.