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

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
cockbilling225249(None) 
backfilling2352613backfilling
cockbill1844943cockbill___
cockbilled2152313cockbill_ed
cockbills1944233cockbill__s
cockling172310393cock___ling
cocktailing2052783cocktailing
corbelling1546713co_rbelling
backbiting2144294backbi_ting
billing103823854____billing
blackballing2352064blackballing
bookbinding2162084bookbinding
bookselling1852264bookselling
caballing1436884__caballing
cackling172610944cack___ling
cavilling1536394__cavilling
chilling143512184__c_hilling
cobbling15248804co__b_bling
cochairing1844654cochai_ring
cockering1839694cock__ering
cockfighting2851344cockfighting
cocking163619984cock____ing
cohabiting1844804cohabi_ting
coiling103723454co___i_ling
combining1637894co_mbi_ning
compelling1746554co_mpelling
compiling1637764co_mpi_ling
controlling1445424controlling
corbeling1439034co_rb_eling
cordelling1446384co_rdelling
corralling1345434co_rralling
counselling1444404counselling
cuckolding2042124cuck_olding
jackrolling2552044jackrolling
killing123118724___k_illing
lowballing1642274lo_wballing
misbilling1545544_misbilling
mothballing1952314mothballing
nickelling1743644nick_elling
outkilling1545264_outkilling
outwilling1445804_outwilling
overbilling1766024overbilling
prebilling1595414_prebilling
rebilling12228834__rebilling
rockabillies206974rockabillies
rockling15259384rock___ling
rototilling1252644rototilling
schilling15286394_sc_hilling
skilling132911334__sk_illing
stockpiling2051564stockpi_ling

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.406440125.6
2DLD Change Limit148819508.92316678.1
3Display Results50500.0163125.0
 (SQL Overall)178691509.34519121.6
 
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.