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

50 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
cowplops174317(None) 
cowflops1842981cowflops
cowplop1643361cowplop_
collops112611752co_llops
complots1438162complots
coplots11511592co_plots
cowflaps1842292cowflaps
cowflop1742892cowflop_
cowslips1543612cowslips
bowpots1446023bowp_ots
clops95924853c___lops
coeloms1139063co_eloms
coemploys1842763coemploys
collop107312313co_llop_
cologs96517353co__logs
colons86028683co__lons
colors86622373co__lors
complies14314523complies
complins14313113complins
complot13310683complo_t
compos124818803comp_o_s
cooktops1644063cooktops
coops96229643co___ops
copilots1255753copilots
copious11311963co_pious
coplot10518273co_plo_t
couplers123311323couplers
couples115317053coupl_es
couplets12389873couplets
coupons112710563coup_ons
cowboys1735253cow_boys
cowflap1742503cowflap_
cowls106922213cow_l__s
cowpats1437713cowp_ats
cowpeas1437273cowp_eas
cowpies143314283cowp_ies
cowpoke1835103cowp_oke
cowpokes1944573cowpokes
cowpox2035003cowp_o_x
cowpoxes2244513cowpoxes
cowslip1444013cowslip_
coypous14248813coyp_ous
cyclops1635383c_yclops
dollops10287963do_llops
joypops2162603joyp_ops
lollops9227443lo_llops
orlops847303_o_rlops
plops95920333___plops
scollops12235703sco_llops
snowplows1751743snowplows

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.423422437.4
2DLD Change Limit146162507.28020077.2
3Display Results50500.0163125.0
 (SQL Overall)178691507.71923149.5
 
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.