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 “retracking” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

120 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
retracking173816(None) 
reracking1639311re_racking
retacking1658971ret_acking
retracing12313291retrac_ing
retracting13311931retracting
detracting1438712detracting
reattacking1843302reattacking
refracting1638732refracting
repacking1838282re_packing
restacking1737182restacking
retackling1744432ret_ackling
retaking133114282ret_a_king
reteaching1636022reteaching
retraining11310242retraining
retroacting1447282retroacting
tracking153715462__tracking
untracking1746932untracking
attacking1635323_attacking
attracting1346563attracting
barracking1944713barracking
beraking153612973be_ra_king
betaking153010153bet_a_king
bethanking2044293bethanking
betraying1537713betra_ying
cracking174013903__cracking
defrocking2143153defrocking
detaching1637263det_aching
deticking1736043det_icking
detraining1267673detraining
extracting2047223extracting
meatpacking2252223meatpacking
outracing12912163outrac_ing
outranking1537673outranking
outrocking1747053outrocking
prefranking2143313prefranking
prepacking2145773pre_packing
pretraining1446503pretraining
protracting1646933protracting
racking144323663___racking
ransacking1744423ransacking
reaching143317203re__aching
reacting113317893re__acting
reattaching1743123reattaching
reawaking17216073reawa_king
rebranching1943383rebranching
rechecking2244463rechecking
recking144319923re___cking
recocking18138373re_cocking
recrating121318793recra_ting
redacting13612303re_dacting
redocking17126783re_docking
redrafting1545963redrafting
redrawing1437213redra_wing
reenacting1357353reenacting
reerecting1339973reerecting
refacing142512813re_fac_ing
refraining1437263refraining
reframing1538623refra_ming
regrading121210203regra_ding
regrafting1545993regrafting
regranting1238323regranting
regrating111316213regra_ting
relacing112516043re_lac_ing
relocking16137683re_locking
remaking152613303re_ma_king
remarking1638893re_marking
reparking1638923re_parking
replacing142210163replac_ing
repricing14310473repric_ing
reproaching1944303reproaching
reraising10313773re_raising
resoaking1439373resoa_king
respacing1438893respac_ing
restocking1745703restocking
restraining1247533restraining
restricting1449303restricting
restriking1548043restr_iking
retagging1236033ret_agging
retailing103214733ret_ailing
retaining102114733ret_aining
retaping113012553ret_a_ping
retarding111110653ret_arding
retasting102513413ret_asting
retaxing162311333ret_a_xing
retching143412173ret__ching
reteaming122110443retea_ming
retearing102214253retea_ring
rethinking1845183rethinking
retouching1644693retouching
retrack131310723retrack___
retracked1657453retrack_ed
retracks14149103retrack__s
retractile1246253retractile
retraction121310533retraction
retractions13910353retractions
retrain7615423retra__in_
retrains8314533retra__ins
retreading12128483retreading
retreating111414773retreating
retrenching1743913retrenching
retrieving1445293retrieving
retrimming1544263retrimming
retroceding1544133retroceding
retrying122410453retr__ying
rewaking162310983re_wa_king
rewrapping1843343rewrapping
sidetracking2052123sidetracking
stacking154215083_st_acking
tacking144421483__t_acking
terracing1237703terrac_ing
tetracaine1245193tetracaine
thacking183110043__thacking
tracing103720153__trac_ing
trackings16247543__trackings
traiking132511973__traiking
tricking152714513__tricking
trocking153612423__trocking
trucking153310163__trucking
untacking1636643unt_acking
wracking18349963__wracking

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.453394461.4
2DLD Change Limit1406031206.37622051.9
3Display Results1201200.0462608.7
 (SQL Overall)1786911206.87525991.4
 
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.