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 “blacksmithings” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
blacksmithings287115(None) 
blacksmithing2761631blacksmithing_
locksmithings2561152_locksmithings
blacksmiths2472143blacksmith___s
locksmithing2461403_locksmithing_
backbitings2252334b_ack_bit_ings
backstitching2771534b_ackstitching_
blacksmith2363074blacksmith____
backbiting2144295b_ack_bit_ing_
backfitting2353075b_ack_fitting_
backsliding2153205b_acksli_ding_
backstabbings2361175b_ackstabbings
backswings2243115b_acks___wings
bakshishing2451775b_a_kshishing_
blackbirding2452005black_birding_
blackenings2042565black___enings
blackings18316765black_____ings
blacklisting2152235black_listing_
blackmailing2351905black_mailing_
blastings12347915bla__s__t_ings
blockbustings2461075blockbust_ings
gunsmithings196895__gunsmithings
locksmiths2152015_locksmith___s
lockstitching2561095_lockstitching_
silversmithings2413925silversmithings
tinsmithings1851315__tinsmithings
babysitting1951616b_abys_itting_
backdating2045716b_ack_dat_ing_
backfilling2352616b_ack_filling_
backfiring2243806b_ack_fi_ring_
backflipping2861456b_ackflipping_
backings174012216b_ack_____ings
backlashing2353436b_ack_lashing_
backlighting2552476b_ack_lighting_
backlisting2043866b_ack_listing_
backscatterings269776b_ackscatterings
backslapping2552086b_ackslapping_
backspacing2452946b_acks_pacing_
backspins1945706b_acks___pin_s
backstabbing2262006b_ackstabbing_
backstairs1844476b_acks__tai_rs
backstamping25112206b_ackstamping_
backstitches2562116b_ackstit_ches
backstopping2552196b_ackstopping_
backswing2144906b_acks___wing_
backwashing2653096b_ack_washing_
bashings144311246b_a__s___hings
bastings114214696b_a__s__t_ings
bearbaitings1751196bea_rbait_ings
beastings12387656bea__s__t_ings
blackballing2352066black_balling_
blackening1944796black___ening_
blackfins2054396black____fin_s
blackfishes2543506black_fish__es
blackguarding2461586blackguarding_
blacking174213606black_____ing_
blackjacking2952166black_jacking_
blackmails2043096black_m__ai_ls
blacktails1843686black___tai_ls
blackthorns2291806black___thorns
blacktopping2551606black_topping_
blandishing1852906bla__ndishing_
blanketing1743326blank__et_ing_
blasting114013436bla__s__t_ing_
blemishing1843516bl___emishing_
blockbusting2361596blockbust_ing_
boardsailings176936boardsai_lings
bracketing1945236brack__et_ing_
flashings16316666fla__s___hings
glassmakings2051556gla_ssm_akings
gunsmithing1851696__gunsmithing_
lashings124412256_la__s___hings
lastings94214426_la__s__t_ings
latchstrings18101286_latchs__trings
lathings12469856_la_____things
lecithins1443986_lec___ithin_s
locksmith2053006_locksmith____
plaitings12296246pla____it_ings
playthings1942366pla____ythings
playwritings2151286pla_ywrit_ings
silversmithing2312976silversmithing_
slashings13316206sla__s___hings
thanksgivings256536thanksgi_vings
tinsmithing1752296__tinsmithing_
transmitting1556096tra_nsmitting_

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 Filter1786911247900.423422437.4
2DLD Change Limit124790859.26313471.9
3Display Results85850.0501700.0
 (SQL Overall)178691859.73618353.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.