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

46 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
columnistic178282(None) 
columnist1346472columnist__
columnists1444362columnist_s
communistic1954382communistic
coloristic1447353col_oristic
columniation1665423columniation
albinistic1454014_albinistic
calumniate1444104calumniat_e
calumniated1652874calumniated
calumniates1553384calumniates
calumniating1752484calumniating
calumniation1663994calumniation
calumniator1552344calumniator
casuistic1344944casu__istic
chauvinistic2261634chauvinistic
cladistic1445684c_l_adistic
colistin10410554col___istin
colitic112916194col___i_tic
colonist102617934col_onist__
colonists112512504col_onist_s
colonitis1148764col_oni_tis
columbic1643444colum___bic
columbite1543974columbi_t_e
columbites1643694columbi_tes
columniations1764794columniations
columns1136474column_s___
communist1548114communist__
communists1646234communist_s
consumeristic1961784consumeristic
cubistic1445704c__u_bistic
dolomitic1445234dolom_i_tic
faunistic1444474_fau_nistic
holistic13311264hol___istic
humanistic1744394__humanistic
melanistic1445874mel_anistic
modernistic1653014modernistic
monistic12311304mo___nistic
nomistic1279594no__m_istic
onanistic1147374_o_nanistic
populistic1644854popu_listic
solecistic1444744sol_ecistic
solipsistic1552604solipsistic
soloistic1147334sol__oistic
totemistic1464324totem_istic
touristic1145634to_u_ristic
violinistic1653084viol_inistic

Search took 9 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.420425454.8
2DLD Change Limit148819468.31317902.0
3Display Results46460.0162875.0
 (SQL Overall)178691468.74920424.2
 
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.