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

109 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
chorusing1524611(None) 
chorussing16193321chorussing
chousing14259421cho_using
carousing1237892carousing
choosing142010132cho_osing
chording15410152chor_ding
choring133617662chor__ing
chortling1535562chortling
chowsing17217342cho_wsing
cohousing1535282cohousing
coursing113112022c_oursing
hocusing1446582_hocusing
horsing113215582_hor_sing
housing113316522_ho_using
aphorising1645743aphorising
arousing93811803aro_using
blousing1138793blo_using
bousing103718043_bo_using
callusing1236173callusing
campusing1654913campusing
caucusing1443803caucusing
causing103614413c__ausing
censusing1244813censusing
charging152910773char_ging
charing133721323char__ing
charking183512613char_king
charming163012033char_ming
charring142913163char_ring
charting142614193char_ting
chasing133715893ch__asing
cheesing14349413ch_eesing
cherishing1944833cherishing
chirking18339383chir_king
chirming16318643chir_ming
chirping16278863chir_ping
chirring142610173chir_ring
chirruping1842053chirruping
chocking204011013cho_cking
choiring14279793cho_iring
choking173911943cho__king
chomping18339883cho_mping
chopping183710263cho_pping
chorine123218363chor__ine
chorus115014773chorus___
chorused1446133chorus_ed
choruses1339983chorus_es
chorussed1543213chorussed
chorusses1444883chorusses
chowing164412773cho__wing
chroming163410723ch_roming
churching2055083churching
churning14237173chur_ning
churring14298653chur_ring
chuting132910733ch__uting
closing103114843clo__sing
closuring1255173closuring
cloturing1245473cloturing
clouding12269493clo_uding
clouring112811273clo_uring
clouting113011683clo_uting
cohousings1642123cohousings
confusing1537333confusing
contusing1239143contusing
cording113620823c_or_ding
coring94433963c_or__ing
corking143018823c_or_king
corning103720123c_or_ning
couping124317023c_o_uping
coursings12235873c_oursings
courting112514573c_ourting
cousin8517163c_o_usin_
cousins9516003c_o_usins
crossing112612683cro_ssing
cruising112610153c__ruising
crushing143010053c__rushing
crusting113612793c__rusting
cursing104217033c_ur_sing
dousing93315763_do_using
focusing1436603_focusing
grousing103410453gro_using
hocussing1544093_hocussing
hoising113414413_ho_ising
hording123517053_hor_ding
horning113015003_hor_ning
hosing103421103_ho__sing
housings12307483_ho_usings
lousing83817733_lo_using
mousing103816273_mo_using
nonusing939233_nonusing
overusing1339043overusing
perusing11811063_perusing
phrasing1438013ph_rasing
rehousing1337253reho_using
rousing83920553_ro_using
shoring112820073shor__ing
shorting122514803shor_ting
shouting122711793sho_uting
shrouding1434753shrouding
sousing83517823_so_using
spousing11198733spo_using
theorising1445183theorising
thorning1237513thor_ning
thouing11258603tho_u_ing
thrusting1335013th_rusting
tousing82916993_to_using
unhorsing1336853unhor_sing
unhousing1335883unho_using
uprousing1235623uprousing
whoring142910293whor__ing

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.440406115.9
2DLD Change Limit1486411097.20320636.0
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.68923239.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.