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

76 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
cracklings1914352(None) 
crackings18346841crack_ings
crackling18157001crackling_
cackling172610942c_ackling_
cracking174013902crack_ing_
crankling16147292crankling_
rocklings16224842_rocklings
tacklings16235852_tacklings
trackings16247542track_ings
backings174012213_back_ings
blackings18316763black_ings
bracings13369293brac__ings
bramblings1742613bramblings
brandlings1443993brandlings
cagelings1335413c_agelings
calkings15289223c_alk_ings
callings113613833c_a_llings
caracoling1545633caracoling_
carjackings2751633carjack_ings
carlings114015863c_a_rlings
catlings113712043c_a_tlings
caulkings1633353c_aulkings
chuckling2144193chuckling_
clacking173313493clack_ing_
cockling172310393c_ockling_
craaling112711353cra_aling_
crackles164111273crackl__es
cracklier1744823crackli_er
crackliest1844883crackliest
cradling122411453cra_dling_
cranking154613073crank_ing_
crankpins17133763crankpin_s
craterings1346003craterings
cravings14428223cra__vings
crawling143110513cra_wling_
cricking173412653crick_ing_
crinkling16145863crinkling_
crocking174313443crock_ing_
crumblings1742513crumblings
cyclings1635373c_yc_lings
darklings1533983_darklings
ducklings17204013_ducklings
franklins1694763franklin_s
freckling1934703freckling_
grapplings1642323grapplings
graylings1433883gra_ylings
hackling183310163_hackling_
mackling172710063_mackling_
packings174310063_pack_ings
prickings18315653prick_ings
prickling1836533prickling_
racings105015133_rac__ings
racking144323663_rack_ing_
railings93412153_ra_ilings
rankings13389173_rank_ings
rankling132610113_rankling_
rattlings10235513_rattlings
ravelings13377383_ravelings
rockling15259383_rockling_
ruckling15258573_ruckling_
sackings15389633_sack_ings
shackling19286173shackling_
spackling18266503spackling_
sucklings16225113_sucklings
tackling153211123_tackling_
trachling1537823trachling_
tracings112910413trac__ings
tracking153715463track_ing_
tracklayings2251133tracklayings
trickling1647723trickling_
truckings16235023truck_ings
trucklines1644293trucklines
truckling1645073truckling_
weaklings1794003wea_klings
wracking18349963wrack_ing_
wreckings19233683wreck_ings

Search took 7 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 Filter1786911406030.406440125.6
2DLD Change Limit140603766.31322272.0
3Display Results76760.0332303.0
 (SQL Overall)178691766.75226464.9
 
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.