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

126 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
churching205508(None) 
churchings2162551churchings
chucking20379502chu_cking
churchgoing2371372churchgoing
churchier1944152churchier
churning14237172chur_ning
churring14298652chur_ring
clutching17154822clutching
couching163213262cou_ching
crunching17297002crunching
crutching17216072crutching
hunching17309112_hunching
hutching17318642_hutching
lurching14277332_lurching
unchurching2251672unchurching
arching136216693__arching
birching16328463_birching
brunching17316483brunching
bunching163410703_bunching
caching156317503c__aching
catching163712773c_atching
chancing162810283chanc_ing
charging152910773char_ging
charing133721323char__ing
charking183512613char_king
charming163012033char_ming
charring142913163char_ring
charting142614193char_ting
checking20379203ch_ecking
cherishing1944833cherishing
chirking18339383chir_king
chirming16318643chir_ming
chirping16278863chir_ping
chirring142610173chir_ring
chocking204011013ch_ocking
chording15410153chor_ding
choring133617663chor__ing
chortling1535563chortling
chorusing15246113chorusing
chroming163410723ch_roming
chuckling2144193chuckling
chuffing2055043chu_ffing
chugging1634913chu_gging
chumming18366203chu_mming
chumping18349063chu_mping
chunking18328053chu_nking
church1636483church___
churched1934653church_ed
churches1846433church_es
churchgoings249963churchgoings
churchiest2044053churchiest
churchlier2052263churchlier
churchly2142973church_ly
churchman2153003churchman
churchmen2142923churchmen
churchy2044183church__y
churnings15233403chur_nings
chuting132910733chu__ting
cinching163310223c_inching
circling1338423c_ircling
clenching17266303clenching
clinching17276123clinching
clucking17429993clu_cking
coaching164011963c_oaching
coercing1349003coerc_ing
couchings17285763cou_chings
coughing15309213cou_ghing
coursing113112023cour_sing
courting112514573cour_ting
cranching17278733cranching
craunching1843313craunching
crouching1746383crouching
crushing143010053cru_shing
curating11314293c_urating
curbing123814023c_ur_bing
curding113515133c_ur_ding
curdling12228893c_urdling
curing94824783c_ur__ing
curling104320183c_ur_ling
curring103616843c_ur_ring
currying14196493c_urrying
cursing104217033c_ur_sing
curving133912103c_ur_ving
douching15349843dou_ching
glunching16174083glunching
grutching16224373grutching
hatching173312213_hatching
hitching173310523_hitching
hotching17309313_hotching
humphing1935163_humphing
hurdling13288013_hurdling
hurling113616413_hur_ling
hurrahing1643753_hurrahing
hurrying15145533_hurrying
hurting113914033_hur_ting
hurtling12318313_hurtling
hushing144514473_hu_shing
inarching1546343inarching
launching1544783launching
lunching143110003_lunching
marching164312193_marching
mouching163110583mou_ching
mulching16287103_mulching
munching16299973_munching
ouching134314903_ou_ching
parching164313053_parching
perching163711633_perching
pouching163210413pou_ching
punching163310123_punching
ruching133612933_ru_ching
scorching1735633scorching
scrunching18163473scrunching
scutching1735223scutching
searching1538343searching
shucking18339433shu_cking
shushing15317743shu_shing
smirching1744393smirching
smutching1734853smutching
sourcing1158353sourc_ing
starching1538593starching
thatching1835143thatching
torching142510083_torching
touching143211343tou_ching
urchin1138743__urchin_
urchins1238863__urchins
vouching17308233vou_ching

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411267.32620289.5
3Display Results1261260.0632000.0
 (SQL Overall)1786911267.82522835.9
 
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.